How to fix chart size regardless of zoom?

[Kelvin Stott]

Hello, I hope somebody can help:

I've written some VBA code to create a chartobject and then save it as a GIF file, which is then loaded into a user form. This all works well and the image looks perfect - however, if I change the zoom of the active worksheet before running the code, the size and resolution of the chart object and resulting image file are changed, so that it looks really bad when loaded into the user form.

Is there any way to fix the size and resolution of the chart object and image, regardless of the current zoom, so that I get consistent & predictable results?

I also tried creating the chart as a chartsheet (rather than a chart object on the current worksheet), but that has its own problems as all the text and image proportions are messed up.

Please help, thanks!

 

[Kelvin Stott]

Please?

 

[Kelvin Stott]

Bump

 

[Jaafar Tribak]

You could run code to temporarly change the worksheet zoom to the zoom that works best for the chart display just before creating the chart and exporting it and then restore the worksheet zoom back to its original value.

Also, (Haven't tested this) but have you tried putting the chart in its own floating window ?

 

[Kelvin Stott]

You could run code to temporarly change the worksheet zoom to the zoom that works best for the chart display just before creating the chart and exporting it and then restore the worksheet zoom back to its original value.

Thanks for your response! I did try this, but it can take a while to calculate and display the chart, so you can actually see the worksheet zoom in and back out, which doesn't look very slick and professional...

Also, (Haven't tested this) but have you tried putting the chart in its own floating window ?

I did think of this and it sounds like it should work, but haven't tried it as I'm not sure how to do it?

 

[Jaafar Tribak]

Thanks for your response! I did try this, but it can take a while to calculate and display the chart, so you can actually see the worksheet zoom in and back out, which doesn't look very slick and professional...

Just thinking out loud here but have you tried turning off screen updating before changing the zoom ?

Edit: Don't change the zoom before creating the chart. Change the zoom just before exporting it.

 

[Kelvin Stott]

Just thinking out loud here but have you tried turning off screen updating before changing the zoom ?

Ooo, that's a nice idea, I'll give it a shot, thanks...

PS. How do I put the chart in its own floating window? I like this idea also...

 

[Jaafar Tribak]

Ooo, that's a nice idea, I'll give it a shot, thanks...

PS. How do I put the chart in its own floating window? I like this idea also...

Did you see my late EDIT in the last post ? lol !

 

[Kelvin Stott]

Did you see my late EDIT in the last post ? lol !

Got it, thanks! Will report back soon ...

 

[Jaafar Tribak]

Right click on the chart and select "Chart Window"