Home |
Search |
Today's Posts |
#1
|
|||
|
|||
interrupted series in a line chart
When I create standard multiple series line charts, when one of my series is
interrupted, excell puts the value at zero by default instead of simply stopping it at the last data point (the data's under consideration are downloads, i.e. the following cells are not 'empty'). I tried to solve the issue with a simple if function, which does not work either. Is there a way to by-pass the default zero value ? |
#2
|
|||
|
|||
If the cells are "EMPTY", Try
Tools - Options - Chart - Plot Empty cells as not plotted. "Patrick" wrote: When I create standard multiple series line charts, when one of my series is interrupted, excell puts the value at zero by default instead of simply stopping it at the last data point (the data's under consideration are downloads, i.e. the following cells are not 'empty'). I tried to solve the issue with a simple if function, which does not work either. Is there a way to by-pass the default zero value ? |
#3
|
|||
|
|||
If the cell contains a formula that evaluates to "" replace the "" with
NA() If the cell is truly empty (no formula, no nothing), BarbR's suggestion should do the job, though you need to select the chart before going selecting the menu item. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... When I create standard multiple series line charts, when one of my series is interrupted, excell puts the value at zero by default instead of simply stopping it at the last data point (the data's under consideration are downloads, i.e. the following cells are not 'empty'). I tried to solve the issue with a simple if function, which does not work either. Is there a way to by-pass the default zero value ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) | |||
Missing values in Excel Line Chart | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |