Merge two Excel graphs into one

ExpExchHelp
ExpExchHelp used Ask the Experts™
on
Quick question... the attached XLS include two (notional) graphs.

My goal is to overlay/include the 2nd graph (personnel trendline) onto/into the 1st graph.

Please keep in mind that this particular example covers two different time scales/range.   That is, graph #1 covers the last four (4) months.   At the same time, graph #2 covers the last four years.   Obviously, we'd be mixing "apples with oranges".  

Still, I'm wondering if it could be achieved.   If the time range has to be the same, I'm okay (for testing purposes) changing the personnel trendline to the last four months as well.

Any recommendations for merging the two graphs into one?

Thanks,
EEH
Graphs.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ExpExchHelpAnalyst

Author

Commented:
Sounds like a plan...

When following the steps (#2) and placing the cursor into the first graph, I then selectd the range (single row that contains Personnel trendline).   At that time, I show the Home toolbar again.

Any suggestion how to interpret step #2 on the page?

Thanks,
EEH
Most Valuable Expert 2011
Top Expert 2011
Commented:
Right-click first chart, choose Select data, Add new series using the data from the second chart and OK out.
Right-click new column, Format Data Series and change to plot on secondary axis. Then right-click again and change chart type to line chart.

HTH
Rory
ExpExchHelpAnalyst

Author

Commented:
Rory:

Your feedback has been very helpful.   Still, I wasn't trying to get this entirely to work yet.  

Once I added the 2nd chart data, it didn't create a 5th column.  Instead, a "tiny slice" sits on top of the 1st column.

See attached XLS and JGP.   What am I doing wrong?

Thanks,
EEH
Graphs.xlsx
Snapshot1.JPG
Most Valuable Expert 2011
Top Expert 2011
Commented:
You entered the values as the series name. Correct that, then right click the new slice, assign it to secondary axis and then change its chart type.
ExpExchHelpAnalyst

Author

Commented:
Rory:

Wow... silly oversight.   Your recommended solution works great!

Thanks,
EEH

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial