Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Stopping chart line where 1 of 2 columns of data in calculation is blank
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 |
#2
|
|||
|
|||
is there not a provision in
tools-opiton-chart plot empty cells - not plotted Roger B. wrote in message ... 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 |
#3
|
|||
|
|||
Hi, works well! Thanks for the tip. Roger
"R.VENKATARAMAN" wrote in message ... is there not a provision in tools-opiton-chart plot empty cells - not plotted Roger B. wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Range Mess | Charts and Charting in Excel | |||
how to show date on the x axis of a line chart? | Charts and Charting in Excel | |||
Goal Line in chart but not on data tabel | Charts and Charting in Excel | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |