| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Broken lines in a chart to display extreme values?
Sometimes a single extreme value causes the rest of the data to become too
small, like a bar chart of the values (10000, 4, 3, 2, 4, 5). The way to avoid is to use broken lines where the axis makes a leap from 10 to 9990 with a dotted gap inbetween. I couldn't find a way to implement this in Excel. Is there a way? |
|
#2
|
|||
|
|||
|
Hi,
It is not a built in option but can be constructed. http://www.andypope.info/charts/brokencolumn.htm Cheers Andy Metin Örsel wrote: Sometimes a single extreme value causes the rest of the data to become too small, like a bar chart of the values (10000, 4, 3, 2, 4, 5). The way to avoid is to use broken lines where the axis makes a leap from 10 to 9990 with a dotted gap inbetween. I couldn't find a way to implement this in Excel. Is there a way? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| How to assign character (text) values to y-axis in a Excel chart? | Charts and Charting in Excel | |||
| Urgent Chart Questions | Excel Discussion (Misc queries) | |||
| How can I minimalize the difference between extreme values on a c. | Charts and Charting in Excel | |||
Linear Mode
