| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I tell excel not to plot certain values in a data series
On a line graph not all my values are numeric. Excel is plotting these
letters at 'zero'. What I prefer is for excel to put in gaps instead. How can I achieve this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I tell excel not to plot certain values in a data series
Either have the cell return the NA() error as in:
=IF(A2=1,A2*2,NA()) if using formulas, or if the cells truly are empty Under Tools-Options - Charts, change the way empty cells are handled. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Tom" wrote: On a line graph not all my values are numeric. Excel is plotting these letters at 'zero'. What I prefer is for excel to put in gaps instead. How can I achieve this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i color points in a plot with a third data series? | Charts and Charting in Excel | |||
| Scatter plot with two data series having common x-values | Charts and Charting in Excel | |||
| how do I plot a data series against two series | Charts and Charting in Excel | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
| How can I plot a data series from multiple worksheets | Charts and Charting in Excel | |||
Linear Mode
