ExcelChart SetChartAxis?

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