B
baldmosher
I have a large dataset that I am currently using to compare Year-To-Date
totals via a series of pivot tables, by region and by country.
There's a column in the data that summarises each YTD totals, i.e. 2006 YTD,
2007 YTD, and Budget 2007 YTD. I use these totals to feed my pivot tables.
However, I now need to analyse the monthly YTD trends in the data. This
means I need to compare the numbers in each monthly column, arranged as
follows: "2006 Jan", "2007 Jan" and "2007 Budget Jan", then "2006 Feb", "2007
Feb", etc.
I eventually need to draw an overlaid line graph showing the trends in all
three.
I have in the past been copying and pasting the data into a template and
updating existing charts, but this only works for one country at a time and
is very laborious.
I am copying & pasting the the above data like this:
Jan Feb Mar Apr...
2006 10 12 12 10...
Budget 11 13 13 11...
2007 8 10 12 14...
What I would like is to have the above displayed in a pivot chart, with the
country name as a Page Field so that I just need to select each country name
to display the trends for that country.
Is it possible to do this via pivot tables?
totals via a series of pivot tables, by region and by country.
There's a column in the data that summarises each YTD totals, i.e. 2006 YTD,
2007 YTD, and Budget 2007 YTD. I use these totals to feed my pivot tables.
However, I now need to analyse the monthly YTD trends in the data. This
means I need to compare the numbers in each monthly column, arranged as
follows: "2006 Jan", "2007 Jan" and "2007 Budget Jan", then "2006 Feb", "2007
Feb", etc.
I eventually need to draw an overlaid line graph showing the trends in all
three.
I have in the past been copying and pasting the data into a template and
updating existing charts, but this only works for one country at a time and
is very laborious.
I am copying & pasting the the above data like this:
Jan Feb Mar Apr...
2006 10 12 12 10...
Budget 11 13 13 11...
2007 8 10 12 14...
What I would like is to have the above displayed in a pivot chart, with the
country name as a Page Field so that I just need to select each country name
to display the trends for that country.
Is it possible to do this via pivot tables?