Combime individual dates in a month in a Pivot Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top