Using Pictographs

Anything in the clipboard can be pasted onto a chart
Book image
Clicking on the coins, copy (ctrl/c), click on a series, Home/paste (or ctrl/v):
Book image
Right-click on the series, use Format Data Series:
Book image
Click these options: [Excel 2003:Patterns tab|Fill Effects]
Book image
There are 3 format options:
  1. Stretch (default)
  2. Stack
  3. Stack and scale to
If we select Stack, we see:
Book image
If we select Stack and scale, we can enter a number into the Unit/Picture box. Again, this is something you can experiment with.
You also may have noticed these options in this dialog:
  • Gradient fill
  • Picture or texture fill
  • And others
Here's the gradient option selected and the Preset colors dropdown:
Book image
The new chart:
Book image
On the picture tab there was a button to select a picture−you can use any picture you have on your computer! You can experiment with the other tabs as well.