comparing averages on chart
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 from different groups and how they performed in monthly tests. What i need to know is how do i place the comparison of averages onto the chart.:confused: -- rushda ------------------------------------------------------------------------ rushda's Profile: http://www.excelforum.com/member.php...o&userid=30541 View this thread: http://www.excelforum.com/showthread...hreadid=501967 |
comparing averages on chart
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 "rushda" wrote: 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 from different groups and how they performed in monthly tests. What i need to know is how do i place the comparison of averages onto the chart.:confused: -- rushda ------------------------------------------------------------------------ rushda's Profile: http://www.excelforum.com/member.php...o&userid=30541 View this thread: http://www.excelforum.com/showthread...hreadid=501967 |
All times are GMT +1. The time now is 12:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com