Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot chart
Hallo,
I usually create charts based upon pivot tables and it all works fine. Now I need to create a chart that uses the data shown on the pivot table, plus the "total average" to be used as a benchmark. The example of the pivot is: Agent Average production Joe 3000 Manuel 5000 Steven 4000 Total average 4000 I would like to have a chart that shows the average production of the agents and the total average production. I can't get Excel 2007 to include that last line in the chart. Can anyone suggest a way? Thanks Maurizio |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot chart
Brian wrote:
Hallo, I usually create charts based upon pivot tables and it all works fine. Now I need to create a chart that uses the data shown on the pivot table, plus the "total average" to be used as a benchmark. The example of the pivot is: Agent Average production Joe 3000 Manuel 5000 Steven 4000 Total average 4000 I would like to have a chart that shows the average production of the agents and the total average production. I can't get Excel 2007 to include that last line in the chart. Can anyone suggest a way? Hi there, I suggest you abandon the pivot chart. Use a pivot table, if you like, to crunch the data, but then lift the results using GETPIVOTDATA to a separate area for charting. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create chart from Pivot table but not Pivot chart? | Charts and Charting in Excel | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
Maintain colour changes in a Pivot Chart when changing Pivot value | Charts and Charting in Excel | |||
How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. | Excel Discussion (Misc queries) |