asked on

Merge two Excel graphs into one

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

ScriptAddict

You could post the second graph's data on a secondary axis, would that work?

http://office.microsoft.com/en-us/excel-help/add-or-remove-a-secondary-axis-in-a-chart-HP010342149.aspx

ExpExchHelp

ASKER

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

ASKER CERTIFIED SOLUTION

Rory Archibald

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ExpExchHelp

ASKER

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

SOLUTION

Rory Archibald

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ExpExchHelp

ASKER

Rory:

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

Thanks,
EEH