Bar Charts

[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.

[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.