comparing averages on chart

[rushda]

I've recently just learnt how to use pivot tables and charts and
I've created a table and chart which deals with different agents fro
different groups and how they performed in monthly tests. What i nee
to know is how do i place the comparison of averages onto th
chart.:confused

 

[ufo_pilot]

Your Data Range will have to be selected from the row(s) or column(s) where
the Average is located
If you do not calculate the average in your data, then you should provide
either row(s) or column(s) for this.
(Use the AVERAGE function)
then use those numbers in your chart