Hi,

You have 3 choices that come to mind:

1. Use two Y-axis - easiest
2. Use a log scale on the Y-axis - may not be appropriate
3. Create a broken Y-axis. - hardest, see Jon's web site.
peltiertech.com/Excel/Charts/index.html


Cheers,
Shane Devenshire


"Karen" wrote:

Using Excel 2003
I am charting some data that has a large range in numbers.
I'm using a clustered column chart that compares values across categories.
The chart has 4 categories of numbers to chart monthly. The problem I'm
having is - in one category, the raw data numbers range from 2000 to 4500 and
another category ranges from 25 to 90. When I chart this data, I cannot
really see much of a bar in the chart for the smaller values. I want to at
least have some bar showing. The minimum on the scale is zero. I thought to
change the scale (Y Axis) minimum to a negative value and that didn't work. I
also thought to show each number value and there's not enough room for that.
Does anyone have any suggestions?

ANY help would be greatly appreciated, Karen