Bar Charts

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
davefowle
Posts: 12
Joined: Wed Nov 22, 2006 10:39 am
Location: London, England

Bar Charts

Post 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.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Bar Charts

Post 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.
Lars Arvidsson, Axolot Data
Post Reply