Thread: Chart Axis
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Karen Karen is offline
external usenet poster
 
Posts: 447
Default Chart Axis

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