ExcelChart SetChartAxis?

[Nilsson_Johan]

I would like to change the ValueAxis caption of a chart. I found the GetChartAxis() function, but even though I change the values on it, it does not change in the exported report.

I checked the MainDemo, but GetChartAxis() is not used anywhere.

This is what I tried

    TChartAxis[] axises = chart.GetChartAxis();

    axises[0].ValueAxis.Caption.LabelValues[0] = "hello";

    axises[0].ValueAxis.Caption.LabelDefinition = "@";

The LabelValues[0] does contain the current value, so I suppose that would be the place to change this. But nothing changes in the output.

There isn't any SetChartAxis().. But is there any equivalent?

Thanks in advance

[adrian]

Hi,

Currently the support for writing things in a chart is limited, and we don't have a setchartaxis yet.

We do have a way to change the series with SetSeries, and you can use it to change the series that contains the axis labels:

 c is a TExcelChart object

		for (int i = 1; i <= c.SeriesCount; i++)
		{
			ChartSeries cs = c.GetSeries(i, true, true, false);   

			switch (i)
			{
				case 1:
					// X-axis labels are on this one
					cs.CategoriesDefinition = "=$B$6:$B$7";

					cs.DataDefinition = "=C6:C7";
					cs.TitleDefinition = "=B7";
					break;

				case 2:
					cs.DataDefinition =  "=B6:C7";
					cs.TitleDefinition = "='Sheet1'!$B$6:$C$7";
					break;

				case 3:
					cs.DataDefinition = "=C5:C7";
					cs.TitleDefinition = "='Sheet1'!$C$5:$C$7";
					break;

			
			}

			c.SetSeries(i, cs);
		}

We have plans for full chart writing for v6.0, along with xlsx chart rendering. In fact the reason we don't support chart writing right now is that xlsx changed everything, and we are waiting to implement it to provide an unified API.

[Nilsson_Johan]

Hello Adrian,

Thank you for your quick response!

Unfortunately I am already using both the DataDefinition and the TitleDefinition of the Series.

Unless there are any other solutions I guess I can append the value of the axis value definition to the serie title definition. I will have to see if this works..

In the meantime;

Do you have any ETA for the release of v6.0?

Will there be support to edit the axis value definition in v6.0?

Thanks in advance

[adrian]

Hi,

We don't have an ETA yet. We will be focusing in xlsx chart rendering and not so much in modification (since it is the most asked feature), but I hope we will be able to add some more editing capabilities including axis modification.