Hints and tips home » Excel hints and tips » Display pictures on Chart Data Point

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.

Added by Orok on 24th October 2006

More Excel hints and tips, like:

• Ctrl+d's double life
• Shortcut for deleting all comments in a spreadsheet
• Move data worksheet to worksheet