Pivot Chart Formatting

C

Cheese_whiz

Hi all,

I have a pivot chart the plots items (y axis) over time (x axis). The time
is in months and years. What I'm trying to do is get it setup so that the
x-axis has only months (which I can do), but there is a graphic
representation in the chart for each year during that month. For example, if
I have data going back to january of last year through july of this year and
I open the report containing the pivot chart set to display the last three
months, then I want to see may, june, july on the x-axis and 2 bars (or
points on two different lines) for each of those months (because I have data
for may of '07 and '08, june of '07 and '08, and july of '07 and '08).

Is that possible?

Thanks,
CW
 

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

Doughnut Chart linked with the slicer in the pivot table 0
Calculate days, months and weeks difrence 0
Pivot table 0
Finding asymptote equation and how to draw them in excel 0
Gantt chart duration not showing 0
Unreadable text when viewing organization chart in Web version of Visio 365 0
simple chart 0
Create a chart from a table in word thats dynamic 0

Top