split y axis for visual clarity
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 |
split y axis for visual clarity
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 |
split y axis for visual clarity
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 |
split y axis for visual clarity
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 |
split y axis for visual clarity
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 |
split y axis for visual clarity
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 |
All times are GMT +1. The time now is 08:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com