Richar
June 17, 2007, 8:32pm
1
I have set up a template in Excel with a chart (graph).
I open the workbook and add data to the chart .
I then insert as an image, the chart, into a word bookmark. However i need to resize the graph before I do this (sizes can vary).
I tried chart.ChartArea.Height = 2000 chart.ChartArea.Width = 2000, doesnt work for me
How do i resize a chart.
Warren
June 17, 2007, 8:54pm
2
Hi,
Please try chart.ChartObject.Width/Height property.
Richar
June 17, 2007, 11:27pm
3
How do i get chart.chartobject.width? following is my code
Dim workbook As Workbook = New Workbook()
workbook.Open("d:\book1.xls")
Dim sheet As Worksheet = workbook.Worksheets(0)
Dim chart As Chart = sheet.Charts.Item(0)
chart.ChartArea.Height = 2000
chart.ChartArea.Width = 2000
workbook.Save("D:\Test.xls")
chart.ChartArea.Height = 2000 doesnt work?????
Hi,
Thanks for considering Aspose.
I think you are using some older version of Aspose.Cells. Please try the latest version 4.3 as chart.ChartObject is included in the newer versions of Aspose.Cells.
Thank you.
Richar
June 18, 2007, 8:03pm
5
Thanks for that I did indeed have an older version, I can now resize a chart, .
I downloaded Aspose.Total 2 weeks ago it had the older version of cells within.