| 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! |
| 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 | |||
Threaded Mode
