Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Have a formula yield a true blank that disconnects graph line
I use a formula to calculate values or use set criteria to yield blanks.
Then I graph the data and want the line graph to end where a blank occurs rather than connect the line to zero where the blank occurs. Actually all blanks are plotted as zeros, but I could enter -1 instead of blank and make the scale minimum zero to eliminate this problem if the line did not connect from the last data point to the -1 or zero. This problem is not cured by copypaste specialvalues even though the blanks then no longer contain formula but look indistinguishable from real blanks. But they do not behave as real blanks, for example, when hitting enddown arrow. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a formula to create a new line of text in a cell? | Excel Worksheet Functions | |||
CAN YOU SET GRAPH TO READ, FORMULA IN A CELL AS A BLANK CELL | Excel Discussion (Misc queries) | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
Stop renaming or moving sheet tabs | Excel Discussion (Misc queries) | |||
Bar graph and line graph overlayed | Charts and Charting in Excel |