Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
i have a chart set up to chart data calculated from a formula, if no data is
entered into the formula the chart plots that perticlar date as zero. How do set it up so nothing is plotted unless a value has been input? |
#2
![]() |
|||
|
|||
![]()
try this
configure the formual so that blanks are enterd as #N/A "matsuda" wrote in message ... i have a chart set up to chart data calculated from a formula, if no data is entered into the formula the chart plots that perticlar date as zero. How do set it up so nothing is plotted unless a value has been input? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Overlay charts in excel | Charts and Charting in Excel | |||
Is there a freeware application for creating gant charts in excel | Charts and Charting in Excel | |||
Excel should be able to do log to base 2 charts | Charts and Charting in Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Why will my Excel charts not print in color? | Charts and Charting in Excel |