Tame your computer – pimp your chart

6 Jan

When you create a column or bar chart,  its elements are filled with solid colours. But sometimes it could be appropriate to draw attention to the information that is presented by using a picture. For example, you could use a photo of a badger to demonstrate the badger population. (With thanks to Ruth and Christina of the Wildlife Trust for Bedfordshire, Cambridgeshire & Northamptonshire for the inspiration!)

Here’s how:

  1. Right-click the vertical or horizontal bar you want to change and select Format Data Series.
  2. In the left pane click on Fill and select the Picture or texture fill radio button. (In Office 2003 you will need to click on the Fill Effects button.)
  3. Click on the File button, navigate to the picture you want to insert and double-click it.
  4. If preferred, select the Stack radio button.
  5. Click Close.

By the way, don’t forget that in Excel you can create a chart in a hurry by selecting the range containing the data that is to appear in the chart and pressing F11.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: