How do I combine two graphs

Question

How do I combine two graphs

Anonymous

I have a simple table of distance (km) and speed (mins/km) versus time. I have created two separate graphs of these. I have been unsuccessful in creating one graph of these with separate y axes. Every time I try to combine them I get ridiculous axes generated by Excel.

Here is the file: https://www.dropbox.com/s/wg757dzznv8y5y3/Exercise_Recovery.xlsx?dl=0

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

1 answer

Answer 1

HansV 462.4K MVP Volunteer Moderator

Add both series to the chart.

Then select one of the series and format it,

Specify that it should be plotted on the secondary axis:

Result:

Share via

How do I combine two graphs

1 answer