+ Reply to Thread
Results 1 to 6 of 6

Adding Secondary Axis on Excel for Column chart

  1. #1
    Registered User
    Join Date
    01-17-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    3

    Post Adding Secondary Axis on Excel for Column chart

    Hello All,

    I need to create an excel chart for three column i.es Month, Amount and Conversion number.

    I need to add secondary axis to show two set of column on different axis but I am unable to. I have attached the image template which I need to create on excel sheet. Please help me to create that secondary axis as mentioned in the image attached.1-17-2018 5-27-35 PM.png

    Really thanks a lot in advance.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,306

    Re: Adding Secondary Axis on Excel for Column chart

    Pictures don't really help us help you, because they don't allow us to see what you have tried and where you are going wrong. Can you describe the steps you are taking to create this chart and what is going wrong when you use those steps? Can you upload a sample Excel file to the forum (go advanced -> Manage attachments)?

    The key steps I would have expected:
    1) How to add a secondary axis to a chart: https://support.office.com/en-us/art...rs=en-US&ad=US
    2) Because that step will likely place one series in front of the other rather than alongside the other, you will need to add blank rows/columns to "stagger" the data.
    Please Login or Register  to view this content.
    What did you try? Does it work if you try these?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    01-17-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    3

    Re: Adding Secondary Axis on Excel for Column chart

    Hello,

    Thanks for replying MrShorty.

    I just want to ask, can we create a clustered column-column bar graph on secondary axis?

    I have followed your link, it is saying for clustered column-line on secondary axis but I am looking for clustered column-column on secondary axis.

    The Image link attached is just showing the type of graph I am looking for. Please follow the image in this link(https://imgur.com/a/gM28t).
    I just want to create exact like this table shown the image. Please follow it once.

    Hope you are understanding my concern.

    Thanks.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,306

    Re: Adding Secondary Axis on Excel for Column chart

    Step 4 from the help file:
    Quote Originally Posted by Excel help
    4. Under Choose the chart type and axis for your data series, check the Secondary Axis box for each data series you want to plot on the secondary axis, and then change their chart type to Line.
    will create a combination chart. However, you are not obligated to change the chart type to line, so you could just check the box for the series you want to be on the secondary axis. That and the adjustments to the data layout I proposed should give the result you show in your picture.

  5. #5
    Registered User
    Join Date
    01-17-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    3

    Re: Adding Secondary Axis on Excel for Column chart

    For the graph type I am looking for, it is not formed by the combination of both the clustered column . I tried making both of them as column then the bar are overlapping over each other.
    I would request you to implement on your excel and then let me know.

    Thanks

  6. #6
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,306

    Re: Adding Secondary Axis on Excel for Column chart

    I won't have an opportunity to upload a file for about 24 hours.
    I tried making both of them as column then the bar are overlapping over each other.
    That sounds like you followed my step 1 from post #2, but ignored or neglected step 2. You need both parts to get the chart you show in your picture.

    If it helps and does not add confusion, this tutorial illustrates the data layout I am envisioning https://peltiertech.com/clustered-st...mn-bar-charts/ If you can think of your chart as a "clustered and stacked column chart with only one stack per cluster and one of the stacks on the secondary axis", that should be a useful tutorial for you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Column/bar chart - shifted secondary axis
    By Rasmusvwn in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-01-2016, 04:37 PM
  2. [SOLVED] Total of column chart on a secondary axis
    By mathieuv in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-25-2015, 04:59 PM
  3. [SOLVED] Adding secondary vertical axis to chart in Excel 2010
    By funkmeister79 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-26-2014, 01:28 PM
  4. Adding reference lines to a chart with primary and secondary axis
    By bennygb07 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-10-2014, 04:34 PM
  5. Adding reference lines to a chart with primary and secondary axis
    By bennygb07 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-10-2014, 04:17 PM
  6. 3D column chart w/ secondary axis?
    By noblecat in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-12-2008, 09:18 PM
  7. [SOLVED] [SOLVED] Can I put a secondary axis on a 3-D column chart in MS Excel?
    By jk432897 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-06-2006, 08:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1