Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Prevent non-numerical data (e.g. text) from plotting on a chart
I want to chart a series of cells. Depending on the assumptions, the data
will either be numbers or text. I only want the chart to plot the numbers. Currently, the chart keeps plotting the text as zeros. Is there any way to prevent the chart from displaying these as zeros (in other words, not plot them at all)? Under toolsoptionschart the default is not to plot blanks, but because the cells are not blank, they show as zeros. |
#2
|
|||
|
|||
There is no such option. You can plot a helper column instead that has
the formula =IF(ISNUMBER(dataRange),dataRange,NA()) Jerry jaweiss wrote: I want to chart a series of cells. Depending on the assumptions, the data will either be numbers or text. I only want the chart to plot the numbers. Currently, the chart keeps plotting the text as zeros. Is there any way to prevent the chart from displaying these as zeros (in other words, not plot them at all)? Under toolsoptionschart the default is not to plot blanks, but because the cells are not blank, they show as zeros. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |