+ Reply to Thread
Results 1 to 5 of 5

Bar Graph With 2 Axis - Bars On The Primary Axis Overlap Bars On The Secondary Axis

  1. #1
    Registered User
    Join Date
    03-08-2013
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Bar Graph With 2 Axis - Bars On The Primary Axis Overlap Bars On The Secondary Axis

    I have a basic bar graph (example attached, I think ExampleGraph.xlsx) that incorporates 2 columns of data at widely different scales. I would like to have one column of data show up as bars tied to the primary axis and the other column show up as bars tied to the secondary axis.

    Unfortunately, when I do that, the bars overlap. Is there any way to push one set of bars to the left side and the other to the right?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Bar Graph With 2 Axis - Bars On The Primary Axis Overlap Bars On The Secondary Axis

    http://peltiertech.com/WordPress/clu...mn-bar-charts/
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-08-2013
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Bar Graph With 2 Axis - Bars On The Primary Axis Overlap Bars On The Secondary Axis

    Thank you for the link. Unfortunately, that link is all about stacked columns, which are not going to help me in this case. I'm not trying to stack information into columns, but instead put data that differ by an order of magnitude or two next to each other in a way that allows them both to be visible.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Bar Graph With 2 Axis - Bars On The Primary Axis Overlap Bars On The Secondary Axis

    The key thing in the artical is the layout of your data in order to avoid the overlap when using both sets of value axis.

  5. #5
    Registered User
    Join Date
    03-08-2013
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Bar Graph With 2 Axis - Bars On The Primary Axis Overlap Bars On The Secondary Axis

    Holy smokes. That was not what I wanted to hear. But if moving the layout around is the only way to do it, I guess I'm stuck with that. Thanks for the help.

    BTW, on the same site (good resource!) I found the following link which describes basically the same concept, but targeted specifically to the question at hand:

    http://peltiertech.com/Excel/Charts/...OnTwoAxes.html

    Also not what I was hoping for, but I suppose I'll just have to deal.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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