+ Reply to Thread
Results 1 to 2 of 2

Clustered column chart (primary and secondary axis)

  1. #1
    Registered User
    Join Date
    12-01-2009
    Location
    Austin, USA
    MS-Off Ver
    Excel 2011
    Posts
    14

    Clustered column chart (primary and secondary axis)

    Hello,

    I have a problem in the alignment of four column in clustered column chart. Two of the columns are on the primary axis (blue and red) and two columns are on the secondary axis (purple and green).

    The problem is the columns with the secondary axis overlap with the column in the primary axis as you can see in the picture. I tried different options with the gap% and overlap%, no success. I want the four column to be adjacent to each other without overlapping and without gap between the columns in the same category.

    Thanks for your help.
    Attached Images Attached Images

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

    Re: Clustered column chart (primary and secondary axis)

    for information on cluster stack combination
    http://peltiertech.com/WordPress/clu...mn-bar-charts/
    Cheers
    Andy
    www.andypope.info

+ 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. Excel chart: Aligning secondary axis with primary
    By Harlort in forum Excel General
    Replies: 3
    Last Post: 04-04-2011, 10:26 AM
  2. Replies: 15
    Last Post: 07-26-2010, 04:35 AM
  3. Replies: 1
    Last Post: 05-03-2006, 09:20 PM
  4. Replies: 2
    Last Post: 05-03-2006, 09:20 PM
  5. Replies: 2
    Last Post: 05-03-2006, 09:20 PM

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