+ Reply to Thread
Results 1 to 1 of 1

Column/bar chart - shifted secondary axis

  1. #1
    Registered User
    Join Date
    05-30-2016
    Location
    Copenhagen
    MS-Off Ver
    2011 Mac
    Posts
    14

    Column/bar chart - shifted secondary axis

    Dear excel guru's,

    I have a problem when trying to illustrate two different kinds of values. The primary axis values are positive in the range 0-5,
    while the secondary axis values are mostly negative in the range 0-(-0.26). My problem is, that the secondary axis is shiftet,
    so that 0 is not in the same vertical place.

    How is this dealt with in a smart way? I have tried to change the bounds for the secondary axis, which can help me in some extent
    but does not give me what I actually wants.

    I hope that you could maybe help me here. A workbook is attached.
    Attached Files Attached Files

+ 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. [SOLVED] Total of column chart on a secondary axis
    By mathieuv in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-25-2015, 04:59 PM
  2. How to do a Stacked Column Waterfall Chart with a Secondary Axis
    By Eric S in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-23-2015, 01:21 PM
  3. Clustered column chart (primary and secondary axis)
    By ziad9933 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-30-2014, 05:22 AM
  4. Stacked column chart with secondary axis
    By jeffreybrown in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-02-2010, 09:45 AM
  5. 3D column chart w/ secondary axis?
    By noblecat in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-12-2008, 09:18 PM
  6. [SOLVED] [SOLVED] Can I put a secondary axis on a 3-D column chart in MS Excel?
    By jk432897 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-06-2006, 08:10 PM
  7. Replies: 0
    Last Post: 07-13-2005, 05:05 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