group by quarters

  • Thread starter Thread starter Michel Peeters
  • Start date Start date
M

Michel Peeters

I have a chart (clustered columns) based on a pivot table.
Sales are grouped by years & quarters.
The quarters are shown in chronological sequence on the X-axis.
But I want the X-axis shows Q1 from Y1, Q1 from Y2, Q1 from Y3, - Q2 from
Y1, Q2 from Y2, etc...instead off in chrnological sequence.
Tks for helping
Michel
 
Sales are grouped by years & quarters.

Try reversing this. Group by quarters, then years and see it gives you what
you want.

HTH,
 
I created a two column array of dates and quantities.

I built the pivottable/chart (using xl2003).

I selected the pivottable sheet and grouped by qtr and year.

Back to the chart sheet and notice two "buttons" at the bottom of the chart.

Years Date

I dragged Date in front of Years and I had what you wanted.

Then I thought: Wow, them pivottables is neat!
 
tks Dave, it is so simple! - michel
Dave Peterson said:
I created a two column array of dates and quantities.

I built the pivottable/chart (using xl2003).

I selected the pivottable sheet and grouped by qtr and year.

Back to the chart sheet and notice two "buttons" at the bottom of the
chart.

Years Date

I dragged Date in front of Years and I had what you wanted.

Then I thought: Wow, them pivottables is neat!
Click to expand...
 
Back
Top