How do I create a Excel bar chart with 3 variables?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to create a bar chart with the width of each bar representing a
third variable. This is similar to the Bubble chart but using bars.
 
I'm trying to create a bar chart with the width of each bar representing a
third variable. This is similar to the Bubble chart but using bars.
Click to expand...

There is a way to do it if you cheat a bit. You can create an Area chart
with a Time-scale axis that follows a rectangular pattern, up, across,
down, across, and so on. Because the Time-scale axis lets you make
vertical lines, this works where the regular Area chart type, with a
category axis, would not. And because it's an Area chart, you can fill
the bars in, which you couldn't do if you did this using an XY scatter
chart type.

Try this out as a demo of the concept, and see if you can adapt it for
your needs:

http://www.branta.demon.co.uk/excel/DCVarBar.xls
 
Back
Top