ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   vba code causes excel charts to decrease in size and become misali (https://www.excelbanter.com/charts-charting-excel/90824-vba-code-causes-excel-charts-decrease-size-become-misali.html)

k2sarah

vba code causes excel charts to decrease in size and become misali
 
i have vba code which changes chart series; exports the chart as a gif file.
When i run the through the code a number of times, the charts size, plotarea
and legendlocation change. does anyone know the cause and solution?
thks
ken

Jon Peltier

vba code causes excel charts to decrease in size and become misali
 
If you shared the offending code, it might help track it down.

I've never had problems with this directly, but I've heard enough complaints
about it. Then this week, one client suffered the problem on a chart I built
for his company. All others using the workbook had no problem, so there
might be something particular about his setup.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"k2sarah" wrote in message
...
i have vba code which changes chart series; exports the chart as a gif
file.
When i run the through the code a number of times, the charts size,
plotarea
and legendlocation change. does anyone know the cause and solution?
thks
ken





All times are GMT +1. The time now is 05:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com