Bar Graph with Pictures

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason - 08 Oct 2007 16:29 GMT

My boss asked me to make a bar graph and spreadsheet that will track
the sales of her employees. She will input there sales at the end of
each day.

Each bar on the graph will be for a different employee and as the bar
grows she wants a picture at the very end to move. For instance if we
were doing a sales event that involved the beach she would want me to
make the bar look like waves and the picture at the end a surfer dude.

Any way to make this happen? If not maybe it could be a scatter plot
with the picture as the marker (don't know how to do this either).

Thanks for any help,

Jason

Reply to this Message

John Mansfield - 09 Oct 2007 00:31 GMT

If you have a shape already on your spreadsheet, click once on the shape. Go
to Edit -> Copy. Then click on the bar / bars of the chart. Go to Edit ->
Paste. This will paste the shape into the chart.

Andy Pope provides more of an explanation using CTRL-C to copy the shape and
CTRL-V to paste the shape into the chart:

http://www.andypope.info/tips/tip009.htm

Signature

John Mansfield
http://cellmatrix.net

> My boss asked me to make a bar graph and spreadsheet that will track
> the sales of her employees. She will input there sales at the end of
[quoted text clipped - 11 lines]
>
> Jason

Reply to this Message

Jason - 10 Oct 2007 17:27 GMT

On Oct 8, 4:31 pm, John Mansfield
<JohnMansfi...@discussions.microsoft.com> wrote:

> If you have a shape already on your spreadsheet, click once on the shape. Go
> to Edit -> Copy. Then click on the bar / bars of the chart. Go to Edit ->
[quoted text clipped - 23 lines]
>
> > Jason

Thanks for the advice John. After I read your advice I thought about
the different types of graphs excel has. Then I got the idea to use a
stacked bar graph. What I did was on the series that is on top I put
the picture, on the bottom series, that measures the sales, I made
invisible (I could have bone waves). Then through some hidden
formulas I subtract the space the picture takes from what has been
sold. This makes the edge of the picture at the point that has been
sold. I also locked the cells and the graph to make sure it is not
messed with. Might have been more work then necessary but it gets the
job done and no one is complaining.

Thanks again John.

Reply to this Message