PlotArea.XRatioToChart

PlotArea.XRatioToChart property

Gets or gets the x coordinate of the upper left corner of plot-area bounding box in units of ratio of the chart area.

public override double XRatioToChart { get; set; }

Remarks

The plot-area bounding box includes the plot area, tick marks(tick labels), and a small border around the tick marks. If the value is not created by MS Excel, please call Chart.Calculate() method before calling this method.

The XRatioToChart, YRatioToChart, WidthRatioToChart and HeightRatioToChart of PlotArea represents the plot-area bounding box that includes the plot area, tick marks(tick labels), and a small border around the tick marks. If you want to get actual size of plot area, you should call InnerXRatioToChart, InnerYRatioToChart, InnerWidthRatioToChart and InnerHeightRatioToChart properties.

For excel 2007 or latter, the default value is zero. you should call get the value after calling Chart.Calculate().

XPixel = XRatioToChart * chart.ChartObject.Width.

Examples

namespace AsposeCellsExamples
{
    using Aspose.Cells;
    using Aspose.Cells.Charts;
    using System;

    public class PlotAreaPropertyXRatioToChartDemo
    {
        public static void Run()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];

            // Add sample data for the chart
            worksheet.Cells["A1"].PutValue("Category");
            worksheet.Cells["A2"].PutValue("A");
            worksheet.Cells["A3"].PutValue("B");
            worksheet.Cells["A4"].PutValue("C");
            worksheet.Cells["B1"].PutValue("Value");
            worksheet.Cells["B2"].PutValue(10);
            worksheet.Cells["B3"].PutValue(20);
            worksheet.Cells["B4"].PutValue(30);

            // Add a chart to the worksheet
            int chartIndex = worksheet.Charts.Add(ChartType.Column, 5, 0, 20, 10);
            Chart chart = worksheet.Charts[chartIndex];
            chart.SetChartDataRange("A1:B4", true);

            // Get the plot area of the chart
            PlotArea plotArea = chart.PlotArea;

            // Display the current XRatioToChart value
            Console.WriteLine("Current XRatioToChart value: " + plotArea.XRatioToChart);

            // Change the XRatioToChart value to move the plot area horizontally
            plotArea.XRatioToChart = 0.2; // 20% from the left of the chart area

            // Display the new XRatioToChart value
            Console.WriteLine("New XRatioToChart value: " + plotArea.XRatioToChart);

            // Save the workbook to see the effect
            workbook.Save("PlotAreaXRatioToChartDemo.xlsx");
        }
    }
}

PlotArea.XRatioToChart