J
Jon Peltier
Belinda -
It's not exactly what you tried to draw, but you could use a Waterfall
chart to show all the costs removed from gross earnings. Here's one link:
http://peltiertech.com/Excel/Charts/Waterfall.html
Your gross income is like the Initial column in my example, and all the
other items in the table are yet another red bar dragging us closer to
zero. Whil I only had Initial and Final as full-height bars, you could
put in a full height bar wherever it makes sense.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
It's not exactly what you tried to draw, but you could use a Waterfall
chart to show all the costs removed from gross earnings. Here's one link:
http://peltiertech.com/Excel/Charts/Waterfall.html
Your gross income is like the Initial column in my example, and all the
other items in the table are yet another red bar dragging us closer to
zero. Whil I only had Initial and Final as full-height bars, you could
put in a full height bar wherever it makes sense.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______