Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
I don't want to graph "null" values?
I am plotting values over time using Excel's graphing feature. The graph
takes data from an adjacent worksheet. I have defined the graph to take data from a large range in the work sheet but not all cells have data in them. I add one piece of data each day to the spreadsheet. The new point is graphed each day. However, all of the null cells following my last point are also plotted as zero. These cells have a "null" value in them not the number zero. How can I stop my plotted graph with the last numerical value? Thanks, Jim |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
I don't want to graph "null" values?
Go to Tools - Options - Chart.
Select: Plot empty cells as "Not Plotted (leave gaps)" Note that if your blank cells are actually formulas, you need to have the formula return NA() instead of "". -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "jfinney" wrote: I am plotting values over time using Excel's graphing feature. The graph takes data from an adjacent worksheet. I have defined the graph to take data from a large range in the work sheet but not all cells have data in them. I add one piece of data each day to the spreadsheet. The new point is graphed each day. However, all of the null cells following my last point are also plotted as zero. These cells have a "null" value in them not the number zero. How can I stop my plotted graph with the last numerical value? Thanks, Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OTHER options for chart not plotting null ("") or zero values | Charts and Charting in Excel | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
cells formatted to tick when text value "Y" if or null if "N" | Excel Discussion (Misc queries) | |||
"IF"- "THEN" type Formula based on Null value | Excel Worksheet Functions | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions |