Jump to content


Photo

Creating a 2 axis chart in excel

charts secondary axis

  • Please log in to reply
1 reply to this topic

#1 Katrina

Katrina

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 06 November 2013 - 04:29 PM

I'm trying to create a chart that has 2 axes; one on the left and one of the right.

 

I have attached my data.

 

Attached File  sales forecast.xlsx   13.78KB   243 downloads

salesforecast.png

 

I want the Salespeople column to be on a separate axis to the Sales column and for Sales to be shown as a line chart instead of a bar chart.  Can you tell me how to do this?



#2 Jonathan

Jonathan

    Forums Administrator

  • Administrators
  • 843 posts

Posted 06 November 2013 - 04:40 PM

Hi Katrina,

 

For in-depth instructions of how to create charts with 2 axis, see Essential Skills Lesson 5-23: Create a chart with two vertical axes.

 

Here's a synopsis of how to do this with your chart:

  1. Right-click on one of the blue bars and click Format Data Series.
    salesforecast2.png

    A dialog will appear.
     
  2. In the dialog that appears, select Secondary Axis.

    A new axis will appear on the right of the chart, plotting the values of your Salespeople on duty.
     
  3. Right-click on one of the blue bars again and click Change Series Chart Type.
    salesforecast3.png

    A dialog will appear.
     
  4. In the dialog that appears, set the Chart Type of the Sales column to Line.

If you have difficulty following these steps, refer to Essential Skills Lesson 5-23: Create a chart with two vertical axes.

 

I have attached a copy of your spreadsheet with the modified chart.

 

Attached File  sales forecast.xlsx   13.98KB   195 downloads

salesforecast4.png


Jonathan is part of the professional team who answer Excel-related questions posted on the ExcelCentral.com forums.
Jonathan also tests our courses prior to publication and has worked on all of our ten world bestselling Excel books for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013.
As well as extensive Excel knowledge, Jonathan has worked in the IT world for over thirteen years as a programmer, database designer and analyst for some of the world's largest companies.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users