We help IT Professionals succeed at work.

Excel bar graph, I want to put in icon image in place of the bar, like boxes or stars. Can this be done?

cdb424ttm
cdb424ttm asked
on
Excel bar graph, I want to put in icon image in place of the bar, like boxes or stars. Can this be done?  I have little images that I want to put inplace of the blue bar on the graph. some one told me this can be done. So instead of having a blue bar go to lets say 10, I'll have ten little stars stacked... Please help..
Comment
Watch Question

Most Valuable Expert 2011
Awarded 2010
Commented:
Hello,

you can use an image as a fill background for a column. Format the data series, on the Fill panel select "Picture or texture fill", click the File button to navigate to the image on your hard drive, tick the "Stack" option and hit OK

cheers, teylyn

stack.png
Commented:
create a bar chart
right click on a bar
format data series
fill
select picture or text fill
Insert From file to pick your stars
Also you may like to choose stack and scale with
Most Valuable Expert 2011
Awarded 2010

Commented:
The screenshot of the chart highlights one of the major problems that arise from picture fills: it's hard to scale them to properly represent the values. In this case, the data values are 1, 2 and 3, but the picture fill show more than one image repeat for a value of 1.

Therefore, although it can be done, it is not a good way of presenting charts. Before you embark on the technique, I recommend you read Jon Peltier's blog post Bad Bar Chart Practices, or Send in the Clowns

cheers, teylyn
Top Expert 2010

Commented:
Jon Peltier is the Greek god of Excel charts!
Most Valuable Expert 2011
Awarded 2010

Commented:
cdb424ttm, I posted exactly the same technique. Can you explain why you did not even acknowledge my comment, which was posted first? This should at least be a points split or assisted solution.