Displaying the data from 2 pivot tables in a graph

LeanidTerbant

New Member
Joined
Nov 15, 2010
Messages
16
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
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,723
You can have more than one series in a chart. A stacked-column chart should do it. (not PivotChart ).
 
Upvote 0

LeanidTerbant

New Member
Joined
Nov 15, 2010
Messages
16
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.
 
Upvote 0

Forum statistics

Threads
1,186,664
Messages
5,959,075
Members
438,396
Latest member
Louise Rodway

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top