Exporting Charts from Excel

**MaximusPrimal** · 11-03-2011, 02:40 AM

Hi.

I am involved in a Breast Cancer charity project which will raise money via donations of women's bras. I use Excel to help keep tabs on what comes in and make notes on items ready for resale to raise money.

I have a spread sheet which has 4 worksheets on it to help organise the data into specific areas and blocks of information to help with updating of our website (www.thebraball.co.uk if you will excuse the plug) rather than having to trawl through the main worksheet each time we update the site with new donation information etc.

I have excel put some of the information into a couple of charts so I can easily update the website and see what sizes, colours etc we have.

I was wondering if it is possible to export these charts directly into HTML format or some other format (such as a Jpeg Image) that I could insert directly into the website rather than have to use HTML tables as I do now and risk making an error in transposing the data from Excel to my website editor (even though I filter the information based on the column contents errors still happen as I am only human sadly).

I have looked in Excel and can see I can export the tables themselves but do not see a way to export the charts short of doing a screen grab and then cropping the image to the right size - which is not good as the various charts are different physical sizes depending on how much information they contain.

Can someone tell me if I can do what I am looking at and if so how.

Thanks
Andy

**teylyn** · 11-03-2011, 05:25 AM

Hello,

try this approach for converting a table or range of cells to an image:
- select the cells you want on the site
- on the Home ribbon click the Copy drop down and select Copy as picture
- accept the defaults and hit OK
- open Word and paste
- right-click the picture in Word and select "Save as Picture"
- give it a name, keep the PNG extension
- upload to your web site.

Excuse the detour with Word, but for some reason, Microsoft did not include the command to save as picture in Excel. It's only in Word and Powerpoint.

cheers,