Discontinuos lines in the same series

  • Thread starter Thread starter routeram
  • Start date Start date
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
 
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/
_______
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set chart series endpoint dynamically 0
syntax to concatenate two named ranges? 2
Line charting the same series using data from multiple sheets? 1
Chart with various Y value ranges 1
Excel charting of 2 unrelated series 1
Input a Value to Lookup the Data Series for a Chart 5
Flops' new build 5
Xbox Series X anomaly (sort of) 4

Back
Top