Hi,
Imagine I have some monthly data about some different issues from 2010 and then I have the same data from 2011. What I want to do is a line chart that would show me month by month values from both years so that I'd know in 2010 our issue #1 had an amount of 10 and in 2011 the amount was 20. And when I put 12 months together that would show me the trend of that issue for 12 months compared by the year.
So if I put 2010 data in one pivot table and 2011 data in another pivot table how can I show both data in one chart?
Or, I can of course make one pivot table containing 2010 and 2011 information but then the question is basically the same: How can I make the chart I want from that one pivot table.
Unless there's no other way I don't want to copy the data to another sheet by hand and then create a chart and etc every time I want to do this.
Thanks in advance,
Meibrah
Imagine I have some monthly data about some different issues from 2010 and then I have the same data from 2011. What I want to do is a line chart that would show me month by month values from both years so that I'd know in 2010 our issue #1 had an amount of 10 and in 2011 the amount was 20. And when I put 12 months together that would show me the trend of that issue for 12 months compared by the year.
So if I put 2010 data in one pivot table and 2011 data in another pivot table how can I show both data in one chart?
Or, I can of course make one pivot table containing 2010 and 2011 information but then the question is basically the same: How can I make the chart I want from that one pivot table.
Unless there's no other way I don't want to copy the data to another sheet by hand and then create a chart and etc every time I want to do this.
Thanks in advance,
Meibrah