Discontinuos lines in the same series

R

routeram

I have 2 discontinuos ranges for a series.
X: AB203:205 AB209:212
Y: AC203:205 Ac209:212

the problem is that this results in a single line while I want it to b
2 separate lines with a gap when the ranges change. Is this possible?
don't want to use 2 series to achieve the same because I keep changin
the range of the series using a macro. This is the only case where
have a discontinuous range. Other cases all have continuous ranges.

Thanks.

Ra
 
J

Jon Peltier

Ram -

Are the cells real blank cells? Select the chart, go to Tools > Options, and on the
Chart tab, choose the Not Plotted option for empty cells.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Top