#1   Report Post  
matsuda
 
Posts: n/a
Default excel charts

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   Report Post  
R.VENKATARAMAN
 
Posts: n/a
Default excel charts

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Overlay charts in excel Amanda Charts and Charting in Excel 6 October 15th 05 04:58 AM
Is there a freeware application for creating gant charts in excel Bryant Charts and Charting in Excel 1 September 16th 05 08:16 PM
Excel should be able to do log to base 2 charts pgb123 Charts and Charting in Excel 2 September 13th 05 01:18 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Why will my Excel charts not print in color? cyncha Charts and Charting in Excel 2 December 5th 04 06:56 PM


All times are GMT +1. The time now is 05:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"