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

See http://peltiertech.com/Excel/Charts/BrokenYAxis.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"cliffordjf" wrote in message
...
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

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"cliffordjf" wrote in message
...
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

http://peltiertech.com/Excel/Charts/BrokenYAxis.html
--
David Biddulph

"cliffordjf" wrote in message
...
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

Is there an echo in this forum?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"David Biddulph" wrote in message
...
http://peltiertech.com/Excel/Charts/BrokenYAxis.html
--
David Biddulph

"cliffordjf" wrote in message
...
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

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

"Jon Peltier" wrote in message
...
Is there an echo in this forum?

"David Biddulph" wrote in message
...
http://peltiertech.com/Excel/Charts/BrokenYAxis.html

"cliffordjf" wrote in message
...
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