Results 1 to 3 of 3

Locking Secondary axis to Primary

Threaded View

  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

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. Secondary Axis Match Primary Axis Gridlines
    By blimbert@stateindustrial.com 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