Displaying the data from 2 pivot tables in a graph

[LeanidTerbant]

Hi
I have 2 pivot tables in Excel 2007, the data from which I need to display on a single graph. 1 pivot table contains data of how many requests for something there were in each year, and the other pivot table contains data of how many requests were responded to in each year.
The catch is that the data doesn't necessarily overlap, e.g. I could make a request in 2007 and not receive a response until 2008. Basically, I want a chart that displays both the number of requests and responses per year.

For example, the first pivot table could contain the following data:
2007: 1 request
2008: 6 requests
2009: 17 requests
2010: 15 requests
And the second could contain the following data:
2007: 0 responses
2008: 6 responses
2009: 14 responses
2010: 11 responses

How can I put that into one column chart?
Thanks

 

[GlennUK]

You can have more than one series in a chart. A stacked-column chart should do it. (not PivotChart ).

 

[LeanidTerbant]

Thanks Glenn

As it happens, I am just in the process of working through a kind of "custom-macro-updating-table-and-graph" solution to avoid the use of pivot tables, which while useful are not the best solution in this case anyway.