We have a requirement to place a callout (like cartoon talk bubble) that points to a particular bar in a bar graph. Is this possible with Aspose Cells? How would we do it?
Hi,
Thank you for considering Aspose.
I am afraid Callout AutoShapes are not yet supported by Aspose.Cells. We will check and see if we can add this feature in our future release.
Thank You & Best Regards,
Thank you for your swift response!
Are all autoshapes unsupported? Or is a subset? Could we construct boxes and lines from other shapes?
Do you know if autoshapes are also unsupported in Aspose.Slides (the chart we generated is destined to live inside a PowerPoint slide.
Hi,
Thank you for considering Aspose.
Well, Aspose.Cells do support some basic AutoShapes like Arc, Arrows, Lines, Rectangle, Oval etc. which you can use to create the Callouts.
Please see the following link regarding the supported AutoShapes with sample codes to implement your scenario,
Thank You & Best Regards,
Thank you again! I'm not giving up hope yet.
I assume can create an oval or rectangle, and draw a line from it, which gets me the bare minimum I need for a speach balloon whose real purpose is to comment on data in a bar graph.
Now the realy trick is tying one ind of that line to the correct bar on the graph.
Is there a way to find a particular bar and tie the line to it? Is there a way to find the coordinates of the bar and then place the line using those coordinates?
Perhaps on a completely different track, is there a way to have a data label show which bar it is describing. Using the Excel application I can put custom text in a data label next to a bar (http://excel.tips.net/Pages/T003007_Locking_Callouts_to_a_Graph_Location.html), but it doesn't have the line that connects the label to the bar so it is not always clear to the viewer which bar is being described. Does Aspose have a way of handling this?
Hi,
Well, currently Aspose.Cells for .NET only supports to add label, textbox or picture into the charts, we may consider adding lines or other controls into the charts, check the doc topic: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/inserting-controls-into-charts.html
I think you can achive your last post's last part. You can put labels using DataLabels.Text property for your need.
e.g..,
//Create a new Workbook.
Workbook workbook = new Workbook();
//Open the existing file.
workbook.Open("f:\\test\\bar_chart.xls");
//Get the designer chart in the second sheet.
Worksheet sheet = workbook.Worksheets[1];
Chart chart = sheet.Charts[0];
//Get the data labels in the data series of the third data point.
DataLabels datalabels = chart.NSeries[0].Points[2].DataLabels;
//Change the text of the label.
datalabels.Text = "Test Label";
datalabels.IsValueShown = true;
//Save the excel file.
workbook.Save("f:\\test\\bar_chart1.xls");
Workbook workbook = new Workbook();
//Open the existing file.
workbook.Open("f:\\test\\bar_chart.xls");
//Get the designer chart in the second sheet.
Worksheet sheet = workbook.Worksheets[1];
Chart chart = sheet.Charts[0];
//Get the data labels in the data series of the third data point.
DataLabels datalabels = chart.NSeries[0].Points[2].DataLabels;
//Change the text of the label.
datalabels.Text = "Test Label";
datalabels.IsValueShown = true;
//Save the excel file.
workbook.Save("f:\\test\\bar_chart1.xls");
And you may also check the doc topic for further reference:
Also, please use our latest version(4.6.0) for it.
Thank you.
That looks like exactly what I need! Thanks!