Hi,
I am using Charts.ToImage to take a chart on a worksheet, and saving it as a .png
As you can see from the two attached files, the y-axis takes up half of the image, thus squeezing the plot area into the right half of the image.
The code I'm using is straightforward:
Dim mysheet As Worksheet = m_appExcel.Worksheets(sSheet)
Dim bitmap As System.Drawing.Bitmap
bitmap = mysheet.Charts(CInt(sEntityNumber) - 1).ToImage()
Dim sFile As String = m_sResultsFolder & "\" & sTitle & ".png"
'Save the chart image file to disk.
bitmap.Save(sFile, System.Drawing.Imaging.ImageFormat.Png)
Can you suggest any way to get around this issue?
Cheers,
Steve