Page 1 of 1
Bar Charts
Posted: Fri Feb 10, 2017 12:22 pm
by davefowle
I am trying to change the "Values" and "Categories" of an existing bar chart to reflect new ranges on the *.XLSX worksheet, using TXLSDrawingEditorChart. However these TXLSDrawingEditorChart properties do not accept values like "$A$1:$A$27
How can I change the Values and Categories?
Thank You.
Re: Bar Charts
Posted: Fri Feb 17, 2017 7:28 am
by larsa
Hello
Don't use TXLSDrawingEditorChart. It's obsolete.
Here is an example on how to set area for series values and categories:
Code: Select all
XLS[0].Drawing.Charts[0].ChartSpace.Chart.PlotArea.BarChart.Shared.Series[0].Cat.NumRef.RCells.SetArea(1,11,1,18);
XLS[0].Drawing.Charts[0].ChartSpace.Chart.PlotArea.BarChart.Shared.Series[0].Val.NumRef.RCells.SetArea(1,11,1,18);
For more info about the RCells property, study the XLSRelCells5 unit.