+ Reply to Thread
Results 1 to 5 of 5

How to make a chart with 2 columns where each column has a different axis?

  1. #1
    Registered User
    Join Date
    05-12-2020
    Location
    Hertzelya Israel
    MS-Off Ver
    16
    Posts
    9

    How to make a chart with 2 columns where each column has a different axis?

    Hello Everyone,
    Lets say I have 2 types of Data (e.g one is quantity and the other one is in $) and I want to put them on the same plot.
    What I need is 2 columns and a secondary axis.
    So, I create a plot of columns with 2 adjacent columns where the measure of each column is on different axis.
    I want to emphasize that I need 2 columns and not a column and a line.
    You see the example picture at the attached file.

    Thanks,
    Koby



    ColumnsTwoAxes_pic.png

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,705

    Re: How to make a chart with 2 columns where each column has a different axis?

    Add two extra columns and write some numbers there
    then
    1. made column graph of all data (4 columns)
    2. format one of real series and one of "empty" series to be plotted on suplementary axis
    3. Right click on a series and select graph data, then move "empty 2" series to the top of the list of series (Top is not necessary, above Value series would be enough)
    4. delete all values in empty series
    5. If legend is needed, then delete unwanted legend entries: click on a legend. Click on unwanted enrty. Press <Del>. Do the same with second unneeded entry

    See attached file with intermediate steps presented
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    05-12-2020
    Location
    Hertzelya Israel
    MS-Off Ver
    16
    Posts
    9

    Re: How to make a chart with 2 columns where each column has a different axis?

    Thanks a lot!
    It was big help!

    Koby

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,705

    Re: How to make a chart with 2 columns where each column has a different axis?

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  5. #5
    Registered User
    Join Date
    05-12-2020
    Location
    Hertzelya Israel
    MS-Off Ver
    16
    Posts
    9

    Re: How to make a chart with 2 columns where each column has a different axis?

    Where is this star? I cannot find it.

    Thanks for your help, It did help a lot. I would still like to keep the question to see if
    there are other solutions.

    Koby

+ 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. [SOLVED] Make a chart with a break Y axis
    By lp_cpa in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-11-2013, 09:07 AM
  2. How do I make a line-column 2-axis chart in Excel 2007?
    By shadestreet in forum Excel General
    Replies: 2
    Last Post: 04-09-2009, 09:35 PM
  3. Chart using one column as vertical axis and others on horizontal axis!!!
    By nandhamnk in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-28-2007, 09:40 AM
  4. Column chart - category axis - make to start with the second label
    By Marko Pinteric in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-10-2006, 04:35 AM
  5. [SOLVED] Column chart - category axis - make to start with the second label
    By Marko Pinteric in forum Excel General
    Replies: 3
    Last Post: 04-10-2006, 04:35 AM
  6. [SOLVED] How do you make a combination chart with 2 axis.
    By smw in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-05-2005, 08:05 PM
  7. Replies: 2
    Last Post: 08-12-2005, 08:05 AM
  8. How do I make the Y axis in an excel chart the category axis?
    By megnadoodle in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-29-2005, 05:06 AM

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