Secondary Axis line chart

[mactoolsix]

In a 2010 Excel chart, can I have different Y-axis scales (a primary and secondary axis) for a line chart?

I see how to make a secondary Y-axis for bar charts, but can't figure out how to apply this to a line chart.

 

[mole999]

this site has everything chartwise > https://peltiertech.com/

 

[mactoolsix]

Thanks for the link, but this site is an add for advanced Excel charting classes. In fact it states "Mostly I ignore these questions"
While it does show some examples (without any explanations) of a secondary axis, I'm still not sure this is available for Excel 2010 line charts.

 

[mole999]

@mactoolsix hmm well if you don't want the help from an acknowledge expert who happens to run a very detailed site, not sure i can point you any better

 

[mactoolsix]

The problem I have with the site is he doesn't answer questions and I don't want to pay $425 for an advanced excel class.
While it may be the all in all expert on charting, I'm looking for a simple answer to a simple question, which is not available on that site.
Thanks for the replies.

 

[PichaiTC]

The way making a secondary Y-axis for line chart is same as in bar charts.
Set Chart Type as Line Chart and set it as Secondary.