Creating combo chart using data located on two different worksheets

[Excel4157]

Hello,

I just created a profile on this forum today. I hope to be helpful to others in the future and look forward to feedback from the community.

Currently I am trying to add a combo chart to a model that I have been working on. One set of data is on one worksheet and the second is on another - would like it to remain that way for other purposes of the model. The x axis shows a date range with corresponding value ranges along the y axis and I would like to combine the two data sets to create a line chart from the values in one sheet and a bar chart along the same x axis with values from the other sheet.

To help illustrate I have attached the two charts below please forgive me if they do not show up, but I think that I inserted the images correctly..)

I have also attached a corresponding workbook. (Note: all numbers in the attached workbook have been changed from the original data source)

PricetoEarnings_1.JPG PricetoEarnings_2.JPG

Thank you in advance for any input and I look forward to contributing in future posts!