How do I save a chart as an image in Excel?

[SonicIce]

I can't printscreen and paste into image editor like usual because the chart is really wide. I'd prefer to save it as a png or other lossless format.

 

[JonnyBlaze]

how wide? only way i can think of would to do it multiple times and create an image as large as you need and keep pasting.

 

[oboeguy]

I am here to save the day. Thank you, thank you, you're too kind, my adoring fans!

Seriously, I just showed the wife how to do this the other day: select the chart with the mouse (the whole chart, mind you, not just the plot area) by clicking it, either hit Ctrl+C or go to Edit | Copy, then "Paste" it into your favorite image editor (e.g. mspaint.exe). From there you can save it however you like. Pwns screenshot method.

If you're up for a little VBA programming, you can write a little program to export the chart to an image file directly: http://support.microsoft.com/kb/q163103/

Edit: clarified last point

 

[SonicIce]

Originally posted by: oboeguy
I am here to save the day. Thank you, thank you, you're too kind, my adoring fans!

Seriously, I just showed the wife how to do this the other day: select the chart with the mouse (the whole chart, mind you, not just the plot area) by clicking it, either hit Ctrl+C or go to Edit | Copy, then "Paste" it into your favorite image editor (e.g. mspaint.exe). From there you can save it however you like. Pwns screenshot method.

If you're up for a little VBA programming, you can write a little program to export the chart to an image file directly: http://support.microsoft.com/kb/q163103/

Edit: clarified last point

:Q You, sir, are a genius

 

[JonnyBlaze]

Originally posted by: SonicIce

Originally posted by: oboeguy
I am here to save the day. Thank you, thank you, you're too kind, my adoring fans!

Seriously, I just showed the wife how to do this the other day: select the chart with the mouse (the whole chart, mind you, not just the plot area) by clicking it, either hit Ctrl+C or go to Edit | Copy, then "Paste" it into your favorite image editor (e.g. mspaint.exe). From there you can save it however you like. Pwns screenshot method.

If you're up for a little VBA programming, you can write a little program to export the chart to an image file directly: http://support.microsoft.com/kb/q163103/

Edit: clarified last point

:Q You, sir, are a genius

yes he is.


im saving this.

 

[Slicedbread]

An easier way would have been to save it as html, and it would have made a page and the gif for you.

 

[SonicIce]

Originally posted by: Slicedbread
An easier way would have been to save it as html, and it would have made a page and the gif for you.

this method works but the graph is not the same dimentions as in excel

 

[SonicIce]

the copy and paste method seems to be working but it looks like it is squishing it very slightly and makes text look funny in some places. pasting into paint shop pro asks me for dimentions, i assume the default ones are correct? and pasting into paint just completely cuts off the right half. in photoshop there is no paste option.