Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Charts

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Charts

Resolved · Low Priority · Version 2003

Reply Mon 19 May 2008, 15:58Delegate Kevin said...

Kevin has attended:
Excel Introduction course

Charts

How do you put photos on to a chart?

For upcoming training course dates see: Pricing & availability

Reply Mon 19 May 2008, 16:05Trainer Pete said...

RE: charts

Hi Kevin
Thanks for the post, welcome to the forum, we discussed this on the course, to put a photograph into the background of the chart, you would rightclick in the Plot area, then choose format Plot Area, from the format dialog box choose Fill Colour and choose the Picture option, then navigate to your picture and click Insert, return to the chart by clicking OK and OK again, your picture will now be behind the bars/etc in your chart, I hope that helped, best regards Pete

Excel articles

· Flexible uses for Excel at Home
· The Secret Formula To Creating Correct Calculations In Excel
· Excel Brings You The Tools To Spice Up Your Spreadsheets
· How To Embed Fonts In Excel
· Data Basics Using Excel

Please browse our web site to find out more about
excel 2003 visual basic intermediate course and other Microsoft training courses.

Excel tip:

Turn off AutoComplete in Excel

You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.

If you find this feature more annoying than useful, you can turn it off by:

1. Going to Tools - Options.

2. Select the Edit tab.

3. Remove the tick from next to the "Enable AutoComplete for cell values" option.

4. Click OK.

View all Excel hints and tips