 |
 |
 |
 |
 |
|
|
||||||||||||
|
#1
10-04-2005, 10:05 AM
|
|||
|
|||
|
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
10-04-2005, 11:05 AM
|
|||
|
|||
|
Re: Broken lines in a chart to display extreme values?
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
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
