Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Plotting blank cells in line charts?
How do I keep a line chart from plotting blank cells. Formulas are in cells
that return a blank when false. |
#2
|
|||
|
|||
The simple way:
1) Hide the rows you don't wish to chart 2) Create a chart. 3) Click Tools, Options, Chart (click on chart first) 4) Uncheck the option to plot visible cells only "doogie" wrote in message ... How do I keep a line chart from plotting blank cells. Formulas are in cells that return a blank when false. |
#3
|
|||
|
|||
=IF(your_formula=0,NA(),your_formula)
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "doogie" wrote in message ... How do I keep a line chart from plotting blank cells. Formulas are in cells that return a blank when false. |
#4
|
|||
|
|||
If you use NA() instead of "" in your formula, XL will interpolate that
point. The only way to create a gap in a XY Scatter chart (any version of XL that supports VBA) or a line chart (prior to XL2002) is to use a programmatic solution such as 'Chart gap for N/A' (http://www.tushar- mehta.com/excel/software/na_discontinuity/index.html) Note that XL2002 introduced a bug wherein a single segment in a line chart cannot be formatted to 'nothing'. MS hasn't fixed the bug as of 2003. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... How do I keep a line chart from plotting blank cells. Formulas are in cells that return a blank when false. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Non Blank - Blank Cells???? | Excel Discussion (Misc queries) | |||
How to force continuous lines in line charts | Charts and Charting in Excel | |||
In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
Automatic copying data excluding blank cells | Excel Worksheet Functions |