Stopping chart line where 1 of 2 columns of data in calculation is blank

R

Roger B.

I have a chart where there are two columns of data used to create a number
in a third column. I have tried to use both #N/A, NA() and "" to stop the
resulting chart line when one of the 2 columns is blank but have had no
success.

Any suggestions would be greatly appreciated,

Roger
 

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

#N/A plotted as 0 on line chart 0
How do I create a scrolling line chart? 0
column charts with set set of data 0
Multiple columns over a chart 0
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Line chart based on 3 columns 0
Odd Chart Format Results 1
Dynamic Charts with sub-groups? 0

Top