+ Reply to Thread
Results 1 to 4 of 4

Bar chart with secondary axis and overlapping bars

  1. #1
    Registered User
    Join Date
    07-17-2013
    Location
    Seattle
    MS-Off Ver
    Excel 2003
    Posts
    5

    Bar chart with secondary axis and overlapping bars

    I have a bar chart using 6 series of data. I would like 3 to be on one axis, and the other 3 to be on the other. for example, I want to have gross margin dollar amounts on the main axis and ggross margin as a percent on the secondary axis. but when I add the secondary axis all my bars overlap. I have attached data so you can see what i am dealing with. any Ideas on how to fix the problem?

    Thanks!

    exel question.xlsx

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Bar chart with secondary axis and overlapping bars

    I can't find anything to suggest that it is possible to do what you want.

    Completely misunderstood your problem. A combination chart using two different chart types will allow two different vertical axis or do as Andy Pope has done and assigned each of the data sets to either the Primary or Secondary axis.
    Last edited by newdoverman; 07-18-2013 at 09:04 AM. Reason: Origninal Post was plainly incorrect.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

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

    Re: Bar chart with secondary axis and overlapping bars

    Just alter the layout of the data.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    07-17-2013
    Location
    Seattle
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Bar chart with secondary axis and overlapping bars

    This is perfect! Thank you so much for your help!

+ 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. Secondary Axis without overlapping bars
    By treva26 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 03-18-2021, 02:58 PM
  2. [SOLVED] Bars overlapping for primary axis data and secondary axis data
    By Lui23 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-19-2013, 05:06 AM
  3. Chart with Secondary Axis but Bars are Overlapping
    By steven_thomas in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-23-2008, 06:20 PM
  4. Replies: 1
    Last Post: 05-03-2006, 09:20 PM
  5. Two bars for a Chart with a Secondary Axis
    By GregBausman in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-01-2005, 07:06 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