+ Reply to Thread
Results 1 to 7 of 7

Overlapping bars in barchart on separate axis

  1. #1
    Registered User
    Join Date
    03-15-2023
    Location
    Amsterdam
    MS-Off Ver
    16.71
    Posts
    6

    Overlapping bars in barchart on separate axis

    Hi! I want to show a cumulative barchart using 2 separate bars consisting of multiple values stacking onto each other.
    Everything seems to be in order, however excel is showing the bars overlapping each other, meaning it is hard to distinguish each.
    I tried changing the overlapping percentage, but that just makes the stacking bar go diagonal. Can someone show me what I am missing?
    I created the chart on macbook, but I also have a windows laptop available as I know it can be easier sometimes.
    Thank you!

    GRAFIEK omzet per kanaal 230301.xlsx

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,780

    Re: Overlapping bars in barchart on separate axis

    The normal methods I would suggest won't work with a pivot chart, but perhaps you could just reduce the gap width of the series on the primary axis so that they are visible around the series on the secondary axis?
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    03-15-2023
    Location
    Amsterdam
    MS-Off Ver
    16.71
    Posts
    6

    Re: Overlapping bars in barchart on separate axis

    It does make it more visible, but if there is a possibility to show them side by side that would create a better overview in my opinion. If not possible, I will stick with the gap width adjustments! thank you

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,780

    Re: Overlapping bars in barchart on separate axis

    I don't think it is possible with a pivot chart - they're not as flexible.

  5. #5
    Registered User
    Join Date
    03-15-2023
    Location
    Amsterdam
    MS-Off Ver
    16.71
    Posts
    6

    Re: Overlapping bars in barchart on separate axis

    Thank you for your quick help, much appreciated. However shame that pivot charts do not support this

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

    Re: Overlapping bars in barchart on separate axis

    I agree with rorya that pivot charts are not likely to support the techniques needed to do what you want. It is possible to create a regular chart using pivot data when you decide that you the limitations of a pivot chart outweigh the advantages. https://peltiertech.com/regular-char...-pivot-tables/
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  7. #7
    Registered User
    Join Date
    03-15-2023
    Location
    Amsterdam
    MS-Off Ver
    16.71
    Posts
    6

    Re: Overlapping bars in barchart on separate axis

    Thanks so much for the help. I dont think the dataset is suitable for a regular chart but I will look into this to see what is possible. Thanks again!

+ 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. Non-overlapping bars when using some series on secondary axis
    By vikas.trades25 in forum Excel General
    Replies: 1
    Last Post: 05-10-2019, 05:26 AM
  3. Replies: 1
    Last Post: 06-22-2016, 05:50 PM
  4. Bar chart with secondary axis and overlapping bars
    By ashley.phillips in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-18-2013, 10:46 AM
  5. [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
  6. Fill of bars in barchart
    By lraeburn in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-22-2011, 03:53 AM
  7. 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

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