If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Many low values, one high value- how do I avoid skewed chart?
I am trying to show a range of values (y-axis) in which on value is much
larger than the rest. I would like to know if anyone can suggest a way to alter the y-axis so that my low values are not grossly skewed by the one high value. Thanks |
#2
|
|||
|
|||
Many low values, one high value- how do I avoid skewed chart?
1. Use a logarithmic scale
2. Make a broken axis: http://peltiertech.com/Excel/Charts/BrokenYAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "bpmedtech" wrote in message ... I am trying to show a range of values (y-axis) in which on value is much larger than the rest. I would like to know if anyone can suggest a way to alter the y-axis so that my low values are not grossly skewed by the one high value. Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Avoid Prompt to Save for Chart | Jon Peltier | Charts and Charting | 2 | June 23rd, 2004 03:19 AM |
Line chart zero values | Walshy | Charts and Charting | 4 | June 16th, 2004 04:09 PM |
Dynamic Offsetting, Names, Arrays, Range, Chart Values. NEED HELP | Bob Lidgard | Worksheet Functions | 14 | February 25th, 2004 03:26 PM |
Chart the Top 3 values | Ryan | Charts and Charting | 1 | December 12th, 2003 05:45 PM |
Styles for chart | Debra Dalgleish | Charts and Charting | 1 | October 3rd, 2003 12:27 PM |