split y axis for visual clarity

C

cliffordjf

I have a data series I want to chart. Most of the data lies within a set
value range; however, there is one (so far) data value that is huge compared
to its neighboring months and this creates a visual problem. To accomodate
the scale range of the one odd data point, all the other data look very small
and it is difficult to see the relative size of the majority of the data as
time goes by.

Is there a way to "split" the scale on the y axis so I can make the majority
of data more visible, with only the top of the odd piece showing above the
split scale?

I hope I asked this correctly

thanks

cliff
 
D

David Biddulph

The time to get worried is when everybody *doesn't* all give that answer,
Jon. :)
 

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

split axis 1
multi dimension/axis single series bar chart 0
Chart - Secondary Y-axis with different values/scale 2
Two sets of intervals on Y axis 3
How to set scale of y axis for time 5
Constant % on X axis 2
Formatting 'X' Axis -- 2 fundamental differences 7
Overlaying 2 Data Series with Different Time (X) Axis 3

Top