| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I want to ignore invalid values in scatter chart
I have an x-y scatter chart which uses values calculated from other sheets in
the workbook. Sometimes these values are invalid, and therefore I use "IF" to render the appropriate cell blank. The entire series then disappears from the chart. I just want that point to bu uncharted. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero values in a log chart | Charts and Charting in Excel | |||
| Create new series (on the same chart) for every change of values in a combobox | Charts and Charting in Excel | |||
| Scatter Chart Axis as text in C# Web appl | Charts and Charting in Excel | |||
| Missing values in Excel Line Chart | Charts and Charting in Excel | |||
| BUG?: Excel scatter chart: will not plot x-values | Excel Discussion (Misc queries) | |||
Threaded Mode
