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?

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?