Understanding Column Chart Capabilities within Excel

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Varying minimum on charts w/o changing for each chart 0
Scatter chart with categories on x-Axis 2
Graphing the maximum and minimum values 7
Charting scientific data - Excel 2003 5
Combining a 2-D column graph and a 2-D line graph on the same char 3
Excel 2007 charts: want to avoid zero values 1
I cannot set the maximum date for the axis of a line chart 5
Formatting 'X' Axis -- 2 fundamental differences 7

Top