Free Support Forum - aspose.com

Chart.ValueAxis.Title

It appears that there is no way to manually set the Chart.ValueAxis.Title or Chart.CategoryAxis.Title property. This is read only. Is there any way to set these values based on variables in the data which drives the chart?

Thanks,
Rick

Hi Rick,

Please set the tiltle like this:

chart.ValueAxis.Title.Text = “AxisTitle”;
chart.CategoryAxis.Title.Text = “CategoryTitle”;

DOH!

Stupid mistake. Why didn’t I think of that!!!

Thanks, Laurence.

Rick

@rschoenborn,
Aspose.Excel is discarded and no more development is done for it. A new advanced product Aspose.Cells has replaced it which contains all the features of Aspose.Excel as well as the latest features in MS Excel. Following example demonstrates creating a chart and setting properties for category and value axis:

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Workbook object
int sheetIndex = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[sheetIndex];

// Adding sample values to cells
worksheet.Cells["A1"].PutValue(50);
worksheet.Cells["A2"].PutValue(100);
worksheet.Cells["A3"].PutValue(150);
worksheet.Cells["B1"].PutValue(60);
worksheet.Cells["B2"].PutValue(32);
worksheet.Cells["B3"].PutValue(50);

// Adding a chart to the worksheet
int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Column, 5, 0, 15, 5);

// Accessing the instance of the newly added chart
Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex];

// Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B3"
chart.NSeries.Add("A1:B3", true);

// Setting the foreground color of the plot area
chart.PlotArea.Area.ForegroundColor = Color.Blue;

// Setting the foreground color of the chart area
chart.ChartArea.Area.ForegroundColor = Color.Yellow;

// Setting the foreground color of the 1st SeriesCollection area
chart.NSeries[0].Area.ForegroundColor = Color.Red;

// Setting the foreground color of the area of the 1st SeriesCollection point
chart.NSeries[0].Points[0].Area.ForegroundColor = Color.Cyan;

// Filling the area of the 2nd SeriesCollection with a gradient
chart.NSeries[1].Area.FillFormat.SetOneColorGradient(Color.Lime, 1, Aspose.Cells.Drawing.GradientStyleType.Horizontal, 1);

// Setting the title of a chart
chart.Title.Text = "Title";

// Setting the font color of the chart title to blue
chart.Title.Font.Color = Color.Blue;

// Setting the title of category axis of the chart
chart.CategoryAxis.Title.Text = "Category";

// Setting the title of value axis of the chart
chart.ValueAxis.Title.Text = "Value";


// Saving the Excel file
workbook.Save("book1.out.xls");

Following document contains detailed description of this feature:
Setting Chart Appearance

Here is a free trial version which can be downloaded from the following link:
Aspose.Cells for .NET (Latest Version)

You can test all the features of this product by downloading a runnable solution here.