Understanding Column Chart Capabilities within Excel

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

I am trying to build a single column type graph.
There are 4 categories of values to graph.
Each category has a maximum and minimum value, which will
be different values.

All of the available column graphs forcethe column bottoms
(minimums) all the way to the X axis. Since my minimum
values for each category have independent and different
minimums, I want to "suspend" them above the X axis.

I need to know if (and how) it can be done.
I have made an image of what I am trying to do in an excel
file that I can send, if my explanation is confusing.
Thanks
WJW
 
Not sure if I understand problem correctly, but - Have you though of adding
a fifth category? Use this to lift the columns ('suspend' them). Then format
this data series with no fill and no border. This is how people make Gnatt
charts.
Bernard
 
Back
Top