On Tue, 29 Jul 2008, in microsoft.public.excel.charting,
John2008 said:
I've been trying to establish an equation in the chart setup wizard to
add the scores based on auditor name and divide it by the number of
instances to come up with the average score.

Don't use the chart wizard to calculate averages, use the spreadsheet.
Then use the chart wizard to display the results.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.