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

graphs

ResolvedVersion 2010

Brett has attended:
Excel Intermediate course

Graphs

How do I have a vertical axis going up from a horizontal axis and also going down so in affect 2 graphs in one with same horizontal axis.

RE: Graphs

Hi Brett

Can I just check. Do you want to set up a graph witrh two vertical axis which share the same horizontal axis?

If so see example attached.

How to set up a chart with 2 vertical axis

First create a normal column chart
Right click on the series you want to be the Secondary vertical axis (in my case temperature)
Choose Format Data Series
Select Secondary Axis

If you want to make the second series a line chart click Change Chart type while the second series is still selected and choose a line chart style.

To add a Secondaty axis title select Layout, Axit Titles
Secondary, Vertical Axis Title, Rotated Title.

Hope that helps. If not please send your example by clicking Upload after posting your reply.

Regards
Doug Dunn
Best STL

Attached files...

2axis Chart.xlsx

Thu 6 Sep 2012: Automatically marked as resolved.

Excel tip:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.