+ Reply to Thread
Results 1 to 3 of 3

Locking Secondary axis to Primary

  1. #1
    Registered User
    Join Date
    09-09-2013
    Location
    Kennesaw, GA, USA
    MS-Off Ver
    Excel 2013
    Posts
    42

    Locking Secondary axis to Primary

    I have been trying to break my new chart that combines stacked bars on the primary axis with their labels on a transparent line graph tied to the secondary axis. The secondary axis allows me to show the labels I want as categories and position them relative to the visible part of the stacked bar (waterfall style) proportionately outside of the bar. The trouble comes when my label positioning is less than or more than the primary boundaries. I can solve this manually by changing the max or min value of the secondary axis, but what I really want is for the secondary axis to be locked to the primary axis' max and min automatically... any ideas?

    gratefully
    grasstoe
    Attached Files Attached Files

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

    Re: Locking Secondary axis to Primary

    Calculate the min and max of the data on both axes.

    The add a series to primary and secondary with those 2 values. If set to auto the axes scales for both should be in snyc without resorting to vba.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-09-2013
    Location
    Kennesaw, GA, USA
    MS-Off Ver
    Excel 2013
    Posts
    42

    Re: Locking Secondary axis to Primary

    Thanks again,

    Just grateful I could turn around and apply your labeling/secondary axis idea for someone else in turn.

    Cheers
    grasstoe

+ 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. Replies: 4
    Last Post: 05-17-2012, 11:25 AM
  2. Replies: 6
    Last Post: 12-07-2010, 02:54 PM
  3. [SOLVED] How to make Primary axis and Secondary X-axis have the same scale
    By AdamCPTD in forum Excel General
    Replies: 0
    Last Post: 07-14-2006, 09:15 AM
  4. Replies: 1
    Last Post: 05-03-2006, 09:20 PM
  5. [SOLVED] Secondary Axis Match Primary Axis Gridlines
    By [email protected] in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-31-2005, 05:05 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