excel charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
try this
configure the formual so that blanks are enterd as #N/A
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I not plot zero values that result from a formula in Excel? 1
Excel Chart 2
"circular" concentric charts - like a pilot's plotting/nav computer 1
Blank instead of "" 5
Template workbook forgets dates for x axis - reverts to 01/01/1900 2
How do I disable "Plot visible cells only" when it is greyed out? 1
Chart type for machine timing diagram? 3
How to create a bubble chart with more than 2 variables 0

Back
Top