Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Null points in a line chart
I have a set of data which I wish to display as a line chart. The problem is,
the data contains both zero values and null values, and when I display the chart, the null values 'revert to zero'. How can I avoid this? Is there a way I can have some interpolated values between valid points rather than have the null values display as zeroes? If not, I would settle for no point displayed at all on the chart. Any help gladly appreciated. |
#2
|
|||
|
|||
A matrix of =IF(a1=NULL,-1,a1)
Then have the -1's off the graph. "rmellison" wrote: I have a set of data which I wish to display as a line chart. The problem is, the data contains both zero values and null values, and when I display the chart, the null values 'revert to zero'. How can I avoid this? Is there a way I can have some interpolated values between valid points rather than have the null values display as zeroes? If not, I would settle for no point displayed at all on the chart. Any help gladly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Drawing Between Separated Data Points ? | Charts and Charting in Excel | |||
Formatting lines between data points in a line chart | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |