| 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 | |||
Linear Mode
