combination graphs

S

srlandrade

New Member
Joined
Mar 1, 2011
Messages
3
How to combine two graphs (lines) that have very different scales?

I would like to have one axis on the right with units from 0 to 5 and one axis on the left with units from 100,000 to 600,00.
One graph will display the number of accidents and the other the number of miles driven.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Sort by date Sort by votes
This is straightforward in Excel.

You need one chart, two data series, and specify that one of them needs to be on the 2nd Y axis.

In Excel 2003, right click on the series you want to be on the 2nd Y axis, Format Data Series, on the Axis tab, select Secondary Axis.
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Solved
Pull Data from Multiple Excel Files into a Summary Excel File to Create Graphs
2
Replies
11
Views
314
NdNoviceHlp
NdNoviceHlp
G
  • Question Question
Excel VBA secondary axis title
Replies
3
Views
468
NdNoviceHlp
NdNoviceHlp
S
  • Question Question
Neep help setting up table for plot graph
Replies
0
Views
407
supermom28115
S
O
  • Question Question
Creating a Graph/Chart needing TWO secondary axis options for a combination of Clustered and Stacked Graph Columns
Replies
0
Views
1K
OrangeJuice
O
S
  • Question Question
How do I make a line graph from this data?
Replies
3
Views
470
awoohaw
awoohaw

Forum statistics

Threads
1,224,590
Messages
6,179,762
Members
452,940
Latest member
rootytrip

Share this page

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
Back
Top