Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Diagram that selects reference area automatically?
I have a to make a x,y-plot, where there in the reference area is not at
corresponding y-value after certain x value €“ the x value where the calculation stops is variable and depending on other things. Because there in the y-cells is a formula that is said to give "", when the calculations is not to be made, the plot looks really funny. Is it possible to do so that the reference area is automatically selected where y0 or so that it will not plot x,y-values, where the y-value is a formula that result that results in "" ? Or should it be another sign than "" I should use? Maybe macros can help me? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Diagram that selects reference area automatically?
Instead of "", use NA().
-- David Biddulph "Flemming" wrote in message ... I have a to make a x,y-plot, where there in the reference area is not at corresponding y-value after certain x value - the x value where the calculation stops is variable and depending on other things. Because there in the y-cells is a formula that is said to give "", when the calculations is not to be made, the plot looks really funny. Is it possible to do so that the reference area is automatically selected where y0 or so that it will not plot x,y-values, where the y-value is a formula that result that results in "" ? Or should it be another sign than "" I should use? Maybe macros can help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I automatically add an area code to a number in a cell? | Excel Worksheet Functions | |||
when I select a cell, it automatically selects 2 or more below | Excel Discussion (Misc queries) | |||
What is a reference area in Microsoft Excel | Excel Discussion (Misc queries) | |||
how do i update a chart area automatically | Charts and Charting in Excel | |||
mouse selects area | Excel Worksheet Functions |