View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default replace axis text with graphics on excel chart (excel 2003)

Hi,

One possible way is to use a dummy data series plotted as an xyscatter.
Then use custom markers.
Jon Peltier has an explanation of using custom markers.
http://peltiertech.com/Excel/ChartsH...ormatting.html

Cheers
Andy

Mad_Hatter_29 wrote:
Hi,
does anyone know how to replace the axis text on an excel chart with
graphics?

So for example if I have a bar chart and the x (vertical) axis has values
from 0 to 100 - I'd like to replace the numbers 0 - 100 with smiley face
graphics - anyone got any ideas?

thanks so much in advance,
Ed.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info