+ Reply to Thread
Results 1 to 2 of 2

Secondary axis on wrong side

  1. #1
    Forum Contributor
    Join Date
    09-30-2015
    Location
    LA my baby
    MS-Off Ver
    2013
    Posts
    727

    Secondary axis on wrong side

    Hello. I create a pivotchart with a secondary axis for column chart. Unfortunately the axis are on the wrong side, the column with the data is on the left side but corresponds to the secondary axis. I tried to switch the order of columns in pivotchart but this just creates the inverse problem. Heeeeelp me.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Secondary axis on wrong side

    The position of the secondary value axis is a property of the secondary horizontal axis. Display the secondary horizontal axis, format it so that the secondary vertical axis crosses the secondary horizontal axis at the desired point, then hide the secondary horizontal axis.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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] how to place two x axis items side by side for one item being described
    By Emma Eve in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 04-21-2015, 12:29 PM
  2. [SOLVED] How to plot data on a secondary axis and show the two data series side by side
    By The_Snook in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-27-2013, 08:41 PM
  3. Axis is on wrong side?
    By Macdave_19 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-24-2008, 09:06 AM
  4. [SOLVED] How do I display columns side-by-side in a two Y axis chart?
    By Kristin C in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-05-2006, 07:40 AM
  5. X Axis on wrong side
    By ArthurJ in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-17-2005, 03:06 PM
  6. [SOLVED] How can i create a graph with 2 x-axis side by side?
    By Sue in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-02-2005, 03:06 PM
  7. [SOLVED] [SOLVED] y axis on wrong side
    By Bill H. in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-07-2005, 11:06 AM

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