| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
scatterplot of data with gaps
Hi,
I'm trying to plot a lot of data with gaps in the columns (empty cells) and would like to be able to plot the series with points omitted if either x or y are zero. It seems that Excel, rather than assume that a blank cell is zero, stops plotting there... Can anyone help me with this? Even assuming zero values would be better... Thanks, Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Threaded Mode
