Home |
Search |
Today's Posts |
#1
|
|||
|
|||
problems with plotting "no data"
Hi,
I use a 3rd party plug-in to retrieve series of time based data, among the data, some of them are listed as "No good data for this time". As the result, the chart plotted them as 0 (instead of leaving them blank). The chart type is scatter. Please help. Thanks |
#2
|
|||
|
|||
You could create another series with the following function
A1 = "No good data for this time" B1 = if(A1="No good data for this time",NA(),A1) "Jeff" wrote in message ... Hi, I use a 3rd party plug-in to retrieve series of time based data, among the data, some of them are listed as "No good data for this time". As the result, the chart plotted them as 0 (instead of leaving them blank). The chart type is scatter. Please help. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting data in Excel | Charts and Charting in Excel | |||
Scatter Graph - Data Label Problems | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
I am having problems creating pivot table of data | Charts and Charting in Excel | |||
Layout/Formatting problems of Data Queries in Excel? | Excel Discussion (Misc queries) |