Secondary Value within Bar

[Pat Daugherty]

I am trying to set up a simple bar chart. Example: Total$
2003, 2002, 2001. Within each of those bars I need to
fill the bar up with another value. Example Total$ was
10000, but 5000 when towards another category. I need to
show the total as 10000, but fill the bar up to 5000 with
another design. Make sense?

 

[Jon Peltier]

Pat -

You could make a stacked bar (or column) chart. In these you do not plot
the total, but all the constituents of the total. If you don't know them
all, use 'Other' and use a formula to subtract all the known
constituents from the total. So your chart would have 5000 of Category A
and 5000 Other.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______