|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 17th, 2007, 03:40 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Chart
When plotting a chart which automatically updates, the last data entry is a
formula but will not have actual data until the information is entered on the next week. On the chart it plots zero - how can I get the chart to not plot this but yet have it included in my source data? 
|
|
#2
July 17th, 2007, 08:22 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel Chart
Hi
that can be done when the formula returns NA() (not available) -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Par3" wrote: When plotting a chart which automatically updates, the last data entry is a formula but will not have actual data until the information is entered on the next week. On the chart it plots zero - how can I get the chart to not plot this but yet have it included in my source data?
|
|
#3
July 17th, 2007, 08:23 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel Chart
Hi,
The formula needs to use NA() rather than zero or "" for periods not yet used. So your formula may look something like this, =IF( test , valuetouse , NA() ) Cheers Andy Par3 wrote: When plotting a chart which automatically updates, the last data entry is a formula but will not have actual data until the information is entered on the next week. On the chart it plots zero - how can I get the chart to not plot this but yet have it included in my source data?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
