| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Hiding 0 values in line charts
I have two columns, one is 2004 Weekly Sales Revenue and one is 2005 Weekly
Sales Revenue. Obviously, 2004 has data for all 52 weeks. 2005 only has data for the weeks-to-date. How can I chart this data on a line graph-- showing comparison between the two years--and not chart the zero values? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| suppress zero values in line charts? | Charts and Charting in Excel | |||
| Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel | |||
| Missing values in Excel Line Chart | Charts and Charting in Excel | |||
| suppress zero values in line charts? | Charts and Charting in Excel | |||
| Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
Threaded Mode
