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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

charts and pivot tables 2
Copying embedded charts 1
how to make grand total to show up on pivotchart? 0
How to create a bubble chart with more than 2 variables 0
How to chart months by financial year 0
Presenting all months in a year in a Pivot Table/Chart when allmonths are not included in source dat 0
Formatting pivot chart axis labels for dates 10
1 for Debra? - Pivot Chart calculated field? 3

Back
Top