Picture as background in a chart

Aspose.Cells Product Family
1

Laurance,

Can I insert a picture as the background fill on a chart in Aspose.Cells? I do this in Excel under Format Plot Area, Fill Effects, Picture. If not, can I use a designer file with a chart on it and add my series to that chart?

Thanks again,

Rob

2

Hi Rob,

Can I insert a picture as the background fill on a chart in Aspose.Cells?

Well, you may implement all types of Fill Effects (Gradient, Texture, Pattern) except Pictures. Hopefully, we may consider it soon in our next releases or so.

can I use a designer file with a chart on it and add my series to that chart?

Yes, you can do it. You can manipulate desinger charts in your template files now. E.g., I add some more data series into the designer chart in a template file (attached):

Workbook workbook = new Workbook();

workbook.Open("d:\\test\\linechart.xls");

Chart chart = workbook.Worksheets[0].Charts[0];

chart.NSeries.Add("{60, 80, 10}", true);

chart.NSeries.Add("{0.3, 0.7, 1.2}", true);

chart.NSeries[3].PlotOnSecondAxis = true;

workbook.Save("d:\\test\\linechart1.xls");

Thank you.

3

Thanks for the fast response. What is critical to our application is the custom background used to plot our X Y scatter points against. I tried as you suggested to open a designer file but he picture background did not show when I saved the file.

rob

4

Hi Rob,

We will get back to you soon for your issue.

Thank you.

5

Hi Rob,

Please try this attached fix.

6

Boy, you guys are good. The background is a .jpg and it works great.

Thanks,

Rob