excel+training - how show two differing

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+training - How to show two differing lots of data in a line graph e.g. diff

excel+training - How to show two differing lots of data in a line graph e.g. diff

resolvedResolved · Low Priority · Version Standard

Geraldine has attended:
Excel Intermediate course

How to show two differing lots of data in a line graph e.g. diff

how to show two differing lots of data in a line graph e.g. different values, showing one data

RE: how to show two differing lots of data in a line graph e.g.

Hello Geraldine,
Hope you enjoyed your Excel training this week.

When the values in a 2-D chart vary widely from data series to data series in a 2-D chart, or when you have mixed types of data (such as price and volume), you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated data series.

To do this you need to select the data series that you want to chart on the secondaruy axis. Sometimes it is difficult to select this series as you may not be abale to see it. In this case you can use the Chart toolbar to select the series from the dropdown list on the left of the toolbar.

HERE IS HOW TO DO IT
Select the data series that you want to plot along a secondary value axis.

On the Format menu, click Selected Data Series.

On the Axis tab, click Secondary axis.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft APPLICATION question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Shortcut for accessing recently opened files

To get into recently opened Excel files without using your mouse, hold down Alt + F to open the File menu.

Recently opened files are listed down the bottom of the File menu - type in the number next to the file you wish to open and it should appear on your screen.

View all Excel hints and tips


Server loaded in 0.08 secs.