Wednesday, February 26th, 2014

Excel – Replace charts with pictures

Enhance your Charts with Visuals

by Helen Bradley
Why have boring old column and bar charts when you can have picture charts instead?

Learn how to replace bars and columns in Excel charts with small images stacked up to show the values being compared.

Image charts like this are one of Excel’s secrets so let me show you how to make them.

In the video you will learn how to replace columns and bars in Excel charts with images. You will see how to find images to use and how to stack and resize the images to fit the chart’s columns and bars.

Helen Bradley

Labels: , , , , , , , ,

Categories:office, video

posted by Helen Bradley @ 4:18 pmNo Comments links to this post

Monday, April 30th, 2012

Save an Excel Chart as a Picture

You can save a chart as a picture from inside Excel so you can use it elsewhere such as in a report or on the web.

To do this you will use a workaround and the simplest way to do it is to size the chart on the worksheet so it is a good size. Choose File > Save As, select the location to save the file in and from the Save As Type dropdown list choose Web Page (*.htm;*.html), type a name and click Save.

This converts the worksheet to an html file and because html files cannot contain images the chart is saved as a separate png image file and linked to the html file.

You can find your chart in the folder that you saved the html file into. So, if your file was called sales.htm then the images will be in a folder called sales_files. Of course, you’ll also need to save your Excel worksheet if you want to save the data and chart to work on in Excel in future.

Helen Bradley

Labels: , , , , ,

Categories:Uncategorized

posted by Helen Bradley @ 8:00 amNo Comments links to this post