| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Skipping Zero values for plots
Hi,
How do I make a chart such that if I have some zero values then those dont get plotted (especially in case of Line charts). Rather if I have values Oct 56 Nov 0 Dec 100 Then I would have only a straight line from Oct to Dec. I might have such zero value pattern for many data points. Is this possible to achieve without any complicated manipulation (I think I have one in mind). regards, HP India |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hiding zero values in charts | Charts and Charting in Excel | |||
| Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
Threaded Mode
