| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
How can I make a bar chart with a pivot table and add a line in it which has
the average value running across and also a median line running across, is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table
Stuster wrote:
How can I make a bar chart with a pivot table and add a line in it which has the average value running across and also a median line running across, is this possible? AFAIK, not possible in a pivot chart. However, you can use another worksheet to copy the pivot table data and add additional columns for plotting average, median, etc. This will give you the flexibility you seek for the chart. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table
awesome, thanks for that
"smartin" wrote: Stuster wrote: How can I make a bar chart with a pivot table and add a line in it which has the average value running across and also a median line running across, is this possible? AFAIK, not possible in a pivot chart. However, you can use another worksheet to copy the pivot table data and add additional columns for plotting average, median, etc. This will give you the flexibility you seek for the chart. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Linear Mode
