Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
graphing data only in a certain range
I am trying to create a graph using data from my table, now some of my data
has blank cells, however they are blank because the formula i am using tells it to be blank, i.e. if (a4<10,"",a4). however when i graph this data it graphs it as a zero value. Is there a way to omit this data from my graph, i have already tried going to the chart option table and selecting plot empty cells as NOT PLOTTED but i think that only applies is there is no formula in the cells. can someone please help me out, or at least point me in the right direction. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
graphing data only in a certain range
I've encountered this before. I don't believe there is an "automatic"
solution. Two options I'm aware of. First, define a new line chart for each data series containing consecutive non-null data. Those separate lines will appear as one sequence (except for the null gaps) if you'll then configure them with the same colors, markers, etc. The second option is to manually hide the null line segments & points (e.g., by coloring them white). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
graphing data only in a certain range
You're right about the treatment of Empty Cells: a formula renders a cell
not empty. Excel assigns a value of zero to cells containing text, and "" is a short piece of text. In a line or XY chart, the #N/A error is not plotted, and the line extends from the point on one side of the #N/A to the point on the other side. Change your formula to =IF(A4<10,NA(),A4) to produce this error value in a cell. If you don't like to see the error in your table, hide it with conditional formatting. Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ .. "Soccerboy83" wrote in message ... I am trying to create a graph using data from my table, now some of my data has blank cells, however they are blank because the formula i am using tells it to be blank, i.e. if (a4<10,"",a4). however when i graph this data it graphs it as a zero value. Is there a way to omit this data from my graph, i have already tried going to the chart option table and selecting plot empty cells as NOT PLOTTED but i think that only applies is there is no formula in the cells. can someone please help me out, or at least point me in the right direction. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graphing Data | Charts and Charting in Excel | |||
Graphing a dynamic range that automatically picks up the most recent entry. | Excel Worksheet Functions | |||
graphing data of different frequencies | Charts and Charting in Excel | |||
graphing a range | Excel Worksheet Functions | |||
Help with graphing log data | Charts and Charting in Excel |