| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Only chart numerical values, not error values
In my data series I am using NA() in a formula so that #N/A shows up in the
cell. From the website listed below I thought that this would not chart the error values but my charts are still conecting all my marks. Can Excel only show my MIN/MAX marks? =IF($B2=MAX($B2:$B$1562),$B2,NA()) http://peltiertech.com/Excel/Charts/FormatMinMax.html Thanks! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Only chart numerical values, not error values
Hi,
If you have #N/A in the cell then the point will not be plotted. But if there is a valid data point(s) after it then the line will be plotted to join those points interpolating the gap in between. It will not leave put a break in the line. This shows you what happens. http://www.andypope.info/charts/brokenlines.htm Or maybe you simply need to format the series so No border is plotted. Cheers Andy andy wrote: In my data series I am using NA() in a formula so that #N/A shows up in the cell. From the website listed below I thought that this would not chart the error values but my charts are still conecting all my marks. Can Excel only show my MIN/MAX marks? =IF($B2=MAX($B2:$B$1562),$B2,NA()) http://peltiertech.com/Excel/Charts/FormatMinMax.html Thanks! |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Only chart numerical values, not error values
My mistake, easy fix. Right-click the data series click 'Format Data Series'
'Patterns' and select 'None' for the line. Thanks Andy. "Andy Pope" wrote: Hi, If you have #N/A in the cell then the point will not be plotted. But if there is a valid data point(s) after it then the line will be plotted to join those points interpolating the gap in between. It will not leave put a break in the line. This shows you what happens. http://www.andypope.info/charts/brokenlines.htm Or maybe you simply need to format the series so No border is plotted. Cheers Andy andy wrote: In my data series I am using NA() in a formula so that #N/A shows up in the cell. From the website listed below I thought that this would not chart the error values but my charts are still conecting all my marks. Can Excel only show my MIN/MAX marks? =IF($B2=MAX($B2:$B$1562),$B2,NA()) http://peltiertech.com/Excel/Charts/FormatMinMax.html Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| Display Error Bar values on chart? | Charts and Charting in Excel | |||
| how do i create a pie chart in excel with non-numerical values? | Charts and Charting in Excel | |||
| Scatter chart without numerical values | Charts and Charting in Excel | |||
| How to omit data in a chart when there are error values? | Charts and Charting in Excel | |||
Linear Mode
