Charts

The UK's most regular instructor-led training courses.
Training information: excel 2003 visual basic intermediate course · Advanced.excel · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Charts

Kevin has attended:
Excel Introduction course

by - delegate Kevin [1 post] (2008 May 19 Mon, 15:58) Reply

How do you put photos on to a chart?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003	2008 Sep 3 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	7	book now	£203	£230
Full Schedule: See all 127 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: charts

by - trainer Pete platinum contributer [799 posts] (2008 May 19 Mon, 16:05) Reply

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

· How Excel Training Can Improve Your Company's Sales Process
· Tips to Facilitate Printing of Excel worksheets
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel

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

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips