If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 ? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
double window envelope | tpdebronsky | Page Layout | 4 | May 17th, 2005 07:34 AM |
Shading a range between two series in a chart | Jon Peltier | Charts and Charting | 0 | May 20th, 2004 03:49 AM |
chartgroups,chartobjects etc-confusion to me | R.VENKATARAMAN | Charts and Charting | 1 | April 10th, 2004 04:09 PM |
build chart template; then add series one by one | L Mehl | Charts and Charting | 2 | February 12th, 2004 10:53 PM |
force graph to axis of choice | bbxrider | Charts and Charting | 2 | February 12th, 2004 09:51 PM |