+ Reply to Thread
Results 1 to 3 of 3

Space between Vertical Y Axis and chart data

  1. #1
    Registered User
    Join Date
    12-04-2015
    Location
    Milpitas, CA
    MS-Off Ver
    2013
    Posts
    3

    Space between Vertical Y Axis and chart data

    Hi,

    I have a stacked area chart with a line chart using a secondary axis. When I added the secondary axis, it made a space between the vertical axis and the chart area. How do I make it so the chart area is flush against the axes?

    Thanks!!!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: Space between Vertical Y Axis and chart data

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced (next to quick post),
    • Scroll down until you see "Manage Attachments",
    • Click that then select "add files" (top right corner).
    • Click "Select Files" find your file, click "open" click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Click "Done" at bottom right to close the Attachment Manager.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    12-04-2015
    Location
    Milpitas, CA
    MS-Off Ver
    2013
    Posts
    3

    Re: Space between Vertical Y Axis and chart data

    A coworker and I figured it out.

    Select Horizontal Axis
    Click Axis Options>Axis Options>Axis Position>On tick marks
    Create Secondary Horizontal Axis and repeat process
    Delete Secondary Horizontal Axis


    Thanks!

+ 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] chart with two vertical axis scales
    By random379 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-16-2015, 11:02 PM
  2. [SOLVED] Grouped vertical axis on chart
    By jwillis07 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-06-2015, 10:29 AM
  3. Replies: 2
    Last Post: 01-22-2015, 03:51 PM
  4. Stacked columns chart - use non-numerical data in the vertical axis
    By guillermo_A in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 07-01-2014, 09:35 AM
  5. [SOLVED] How to draw a chart horizontal axis and vertical axis
    By kiany406 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-17-2012, 02:56 PM
  6. Remove extra vertical space in Gantt chart
    By run4it in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-03-2009, 06:57 PM
  7. Chart using one column as vertical axis and others on horizontal axis!!!
    By nandhamnk in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-28-2007, 09:40 AM

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