Format Chart Title... dialog window not displaying!

Aspose.Cells Product Family
1

Any ideas as to why the “Format Chart Title…” dialog window is not displaying? When you right-click over the Chart Title the menu option appears to display the “Format Chart Title…” or “Clear” text but the dialog window does not launch.

2

Could you please post your file to show this problem? Thank you.

3

See attached file.

4

I will check this issue. Is this chart totally created by Aspose.Excel at run time, or imported from a template?

5

This is really a strange problem. Please try the attached fix.

If you still find this problem, could you please post your code here? Thank you.


And you can also try my test code:

Excel E = new Excel();
E.Worksheets.Add();

Cells C = E.Worksheets[0].Cells;

C.SetColumnWidth(0, 10);
C.SetColumnWidth(1, 10);
C[0, 0].PutValue("Age");
C[0, 1].PutValue("Income");
double Income = 50000.00;

for(int i = 1; i < 52; i++)
{
C[i, 0].PutValue(i-1);
C[i, 1].PutValue(Income);
C[i, 1].Style.Number = 42;
Income = Income + (Income * 0.05);
}

int ChartIndex = E.Worksheets[1].Charts.Add(ChartType.Bar3DClustered, 0, 0, 50, 20);
Aspose.Excel.Chart Ch = E.Worksheets[1].Charts[0];

Ch.NSeries.Add("Sheet1!B2:B52", true);
Ch.NSeries.CategoryData = "Sheet1!A2:A52";

Aspose.Excel.ASeries S;
S = Ch.NSeries[0];
S.Name = "=Sheet1!B1";

Ch.CategoryAxis.TickLabelSpacing = 1;
Ch.CategoryAxis.TickMarkSpacing = 1;

Ch.IsLegendShown = true;
Ch.Title.Text = "Age vs. Income";

E.Save("chart.xls", SaveType.OpenInExcel, FileFormatType.Default, this.Response);

6

Thanks. I won’t have time to try this until tomorrow morning. If the new dll doesn’t solve it I’ll post my code and another copy of the Excel file produced.

7

The dll you provided did not change the behavior. My code is attached. The dialog window is still not displaying. This is not a major issue as I’m able to control the format and content of the chart title through the api. I’m more interested in the DataTable which at this time can not be formatted through the api…I think the plan is to implement that functionality by July.

In the mean time I’ll probably use multiple designer templates that already contain the formatting I need. Thanks for your help.

8

@heathde,
Aspose.Excel is discontinued now and is no more available. It is replaced by Aspose.Cells that supports all the latest features of different versions of MS Excel. It also supports the creation of a variety of charts and the formatting of chart titles. Here is a sample code that demonstrates the creation of a chart and the formatting of the chart title.

// Create workbook object
Workbook wb = new Workbook();

// Access first worksheet
Worksheet sheet = wb.Worksheets[0];

// Add Toggle Button ActiveX Control inside the Shape Collection
Shape s = sheet.Shapes.AddActiveXControl(ControlType.Label, 4, 0, 4, 0, 100, 30);

Workbook workbook = new Workbook(FileFormatType.Xlsx);
//Worksheet sheet = workbook.Worksheets[0];

// Put data
sheet.Cells[0, 0].PutValue(1);
sheet.Cells[0, 1].PutValue(2);
sheet.Cells[0, 2].PutValue(3);

sheet.Cells[1, 0].PutValue(4);
sheet.Cells[1, 1].PutValue(5);
sheet.Cells[1, 2].PutValue(6);

sheet.Cells[2, 0].PutValue(7);
sheet.Cells[2, 1].PutValue(8);
sheet.Cells[2, 2].PutValue(9);

// Generate the chart
int chartIndex = sheet.Charts.Add(Aspose.Cells.Charts.ChartType.ScatterConnectedByLinesWithDataMarker, 5, 1, 24, 10);
Chart chart = sheet.Charts[chartIndex];

chart.Title.Text = "Test";

//Here you may format the title
chart.Title.Font.IsBold = true;

chart.CategoryAxis.Title.Text = "X-Axis";
chart.ValueAxis.Title.Text = "Y-Axis";

chart.NSeries.CategoryData = "A1:C1";

// Insert series
chart.NSeries.Add("A2:C2", false);

Series series = chart.NSeries[0];

int pointCount = series.Points.Count;
for (int i = 0; i < pointCount; i++)
{
    ChartPoint pointIndex = series.Points[i];

    pointIndex.DataLabels.Text = "My Series 1" + "\n" + "My Point " + i;
}

// Insert series
chart.NSeries.Add("A3:C3", false);

series = chart.NSeries[1];

pointCount = series.Points.Count;
for (int i = 0; i < pointCount; i++)
{
    ChartPoint pointIndex = series.Points[i];

    pointIndex.DataLabels.Text = "My Series 2" + "\n" + "My Point " + i;
}

workbook.Save("output_out.xlsx", Aspose.Cells.SaveFormat.Xlsx);

You may visit the following article for more details about setting chart appearance:
Setting chart appearance

For trials purpose, download the latest version here:
Aspose.Cells for .NET (Latest Version)

Here is a ready to run solution which can be used to test the product features with minimal effort.