| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
ignore missing values while ploting graph
what commands do i need to give in order to ignore the missing values when i
am plotting the curve. By ignoring the missing values I will not get any breaks in the plot |
|
#2
|
|||
|
|||
|
Excel plot Wrote: what commands do i need to give in order to ignore the missing values when i am plotting the curve. By ignoring the missing values I will not get any breaks in the plot Hi Excel plot Use #N/A, this will be ignored -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=467925 |
|
#3
|
|||
|
|||
|
Using the ctrl key, only highlight the cells with values and Insert - Chart.
"Excel plot" wrote: what commands do i need to give in order to ignore the missing values when i am plotting the curve. By ignoring the missing values I will not get any breaks in the plot |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to ignore zero values when plotting a graph | Charts and Charting in Excel | |||
| Displaying values from zero on graph | Excel Discussion (Misc queries) | |||
| Missing values in Excel Line Chart | Charts and Charting in Excel | |||
| Bar graph values keep changing | Charts and Charting in Excel | |||
| how can i get the slope function to ignore missing data? | Excel Discussion (Misc queries) | |||
Linear Mode
