+ Reply to Thread
Results 1 to 2 of 2

Excel Chart: how to make a similar excel chart like this?

  1. #1
    Forum Contributor
    Join Date
    09-10-2016
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    678

    Excel Chart: how to make a similar excel chart like this?

    Maybe it is not the right forum, but I visit this board VBA/Macro often, and I think people are very knowledgeable, so I choose to ask the question here.

    Attached: Is it possible for have some kind of similar excel chart (TWO y axis)?

    Thanks.

    John Mike
    1Q Income 25000 16900
    2Q Income 26000 20000
    3Q Income 27000 23000
    4Q Income 26500 26000
    # of Hrs Worked during the Year 2500 2800
    Attached Images Attached Images

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

    Re: Excel Chart: how to make a similar excel chart like this?

    To get two Y axes, you need to select one of the data series -> format series -> move to secondary axis. In this case here, select the data, insert a stacked column chart, move the hours worked series to the secondary axis, and format as desired. Note that Excel's tendency is to put the secondary axis column in front of the primary axis column, so you may need to make the hours worked series smaller than the primary axis series and/or make it partially transparent. In order to move the secondary axis column to the side, you need to follow a "clustered and stacked" type approach -- that is mostly about arranging the data in a "staggered" type arrangement in the spreadsheet: https://peltiertech.com/clustered-st...mn-bar-charts/
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. How to make ecg chart excel
    By hamzasilwady in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-15-2015, 02:06 PM
  2. [SOLVED] Excel VBA - how to make a excel vb chart diagram with 2 variables.
    By svein erik endresen in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-01-2013, 10:55 AM
  3. Replies: 0
    Last Post: 11-20-2012, 05:14 AM
  4. How do you make this chart in Excel?
    By KoolSIM in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-02-2012, 01:34 AM
  5. Replies: 2
    Last Post: 08-30-2012, 07:12 AM
  6. Can Excel make this chart?
    By switters in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-04-2008, 01:40 AM
  7. [SOLVED] How to make a chart in excel
    By help in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-24-2005, 10:48 AM

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