Line Chart

  • Thread starter Thread starter Nan
  • Start date Start date
N

Nan

I'm setting up a line chart that is updated daily. I would like to se
it up a month in advance so that the user only has to type in the ne
data and the chart updates automatically. The chart data is linked t
cells on different worksheets. The cells that the chart is linked t
contain formulas (AVERAGE). Is there a way to prevent the line fro
dropping to the X axis when there is no data yet?

For example, data for April 8 has yet to be entered. The cell for Apri
8 data (which contains the AVERAGE formula) has #DIV/0! in it becaus
no data has yet to be entered. This makes my chart drop to the X axi
for April 8.

Any help is greatly appreciated
 
Hi
try changing your formula with the division to something like
=IF(B1=0,NA(),A1/B1)
to return #NA in case of a division by zero. This cell shouldn't be
charted
 
I'm still having problems. I modified your formula (and maybe that's th
problem) to be IF(H4=0,NA(),AVERAGE(H4:H32). I want the average of th
H column, regardless of how many entries there may be (there may b
only 5 on a given day). I still get the division error.

I tried this formula as well....IF(H4="","",AVERAGE(H4:H32). Thi
leaves the cell blank (which is good). However, it messes up my chart.

Part of my problem may also be that, because I have so many sheets,
created a separate sheet with the chart data (linked to all the othe
sheets). Therefore, I need a formula in the chart data sheet that m
chart thinks is blank and won't graph.

I hope that makes sense
 
Hi
what is in the range H4:H32. If there's at leat one entry AVERAGE
should not return an error. Or are there error values in the range
H4:H32
 
There's nothing in the H4:H32 range. I'm trying to set it up for th
user for a future date so they don't have to do it
 
Back
Top