| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combime individual dates in a month in a Pivot Chart
I have a Pivot Chart with individual dates as line items, and I would like to
combine those into months. How do I do that? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combime individual dates in a month in a Pivot Chart
Hi,
In the pivot table, not the chart, place your cursor in the Date column, then choose the command Pivot Table, Group and Show Detail, Group. In the dialog box pick Month and Day (or whatever you want) and click OK. Now your pivot table will have a month field which will/can be plotted as a second x-axis field or as the only x-axis field. -- Cheers, Shane Devenshire "yakdog" wrote: I have a Pivot Chart with individual dates as line items, and I would like to combine those into months. How do I do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| marker style change for an individual month | Charts and Charting in Excel | |||
| pivot chart is it possible to hide individual field buttons? Layout Field buttons | Charts and Charting in Excel | |||
| Pivot table - group dates per week or month | Excel Discussion (Misc queries) | |||
| How do I get the average price per bid for an individual month? | Excel Discussion (Misc queries) | |||
| Counting individual dates | Excel Discussion (Misc queries) | |||
Linear Mode
