Chart Help

  • Thread starter Thread starter Kelly McFaul
  • Start date Start date
K

Kelly McFaul

I have a chart with several columns of data that has column A as the X axis
and any one of columns B through M can be plotted on a left Y axis and a
right Y axis to compare two columns of data at the same time.
This chart might have 100 rows of data or 600 rows of data. I figured out
how to automatically update this chart with the number of rows of data I
have thanks to Jon Peletier's great tips on his website. : )
BUT..... my question is this: I would like to insert a column to figure out
the average of the first 3 columns. The only way I know how to do this is to
put the formula in the first cell of the first row then fill it down to the
end of the data.

Since the number of rows will vary, is there a way to automatically
calculate the average for the number of rows I have in the sheet?

I hope I explained this clearly...... I'm stumped.
Thanks,
Kelly
I'm using Excel 2000
 
Whatever named formula you created to plot the dynamically selected
data, use the same name in the AVERAGE formula, i.e., =AVERAGE(<named-
formula>)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Microsoft MVP -- Excel
 
Kelly -

If you want an average of each column of the first three columns, put
the formula in the top cell and fill it down 600 rows. Then define a
named range based not on the length of this column, which is always 600,
but on the length of one of the columns included in the average.

- Jon
 
Back
Top