Hi,
Assume we are not showing legends. If so entire plot will cover chart area.
I want to adjust plot area just that even though Legends are not show. How can we adjust plot area in the chart??
Mithun
Hi,
The chart area is big enough as 4000 units for 2003 Excel. The value is dynamic, we need to calculate by the chart size. We created a test based on your codes. Please check the attached archive. Hope, it will help you to understand for your needs.
In short please set the plot position accordingly.
e.g (by using):
chart.PlotArea.X = ?
chart.PlotArea.Y = ?
chart.PlotArea.Width = ?
chart.PlotArea.Height = ?
Thanks.
Attachment doesnt open… Takes me to yellow page.
Hi,
It is a zipped archive which contains Excel files with sample codes and screen shots. Please use WinZip, WinRAR tool to unzip it.
Thank you.