Hi,
I have a dataset which contains a few outliers. Therefore, charts are distorted. It would help a lot if I coulde break the graph in two to create a graph of which the y-axis runs from e.g. 0 to 200, then breaks, and continues from 600 up... is this possible?
Thanks in advance,
Peter
Take a look at this link, it seems to provide what you want?
http://peltiertech.com/Excel/Charts/BrokenYAxis.html
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks