Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / January 2007

Tip: Looking for answers? Try searching our database.

split y axis for visual clarity

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
cliffordjf - 30 Jan 2007 17:44 GMT
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
Bernard Liengme - 30 Jan 2007 17:58 GMT
See http://peltiertech.com/Excel/Charts/BrokenYAxis.html
best wishes
Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>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
[quoted text clipped - 17 lines]
>
> cliff
Jon Peltier - 30 Jan 2007 17:58 GMT
http://peltiertech.com/Excel/Charts/BrokenYAxis.html

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

>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
[quoted text clipped - 17 lines]
>
> cliff
David Biddulph - 30 Jan 2007 18:04 GMT
http://peltiertech.com/Excel/Charts/BrokenYAxis.html
Signature

David Biddulph

>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
[quoted text clipped - 17 lines]
>
> cliff
Jon Peltier - 30 Jan 2007 18:23 GMT
Is there an echo in this forum?

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

> http://peltiertech.com/Excel/Charts/BrokenYAxis.html
>>I have a data series I want to chart.  Most of the data lies within a set
[quoted text clipped - 19 lines]
>>
>> cliff
David Biddulph - 30 Jan 2007 20:26 GMT
The time to get worried is when everybody *doesn't* all give that answer,
Jon.  :-)
Signature

David Biddulph

> Is there an echo in this forum?

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

>>>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
[quoted text clipped - 18 lines]
>>>
>>> cliff
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.