+ Reply to Thread
Results 1 to 5 of 5

excel chart multi level axis remove separators

  1. #1
    Registered User
    Join Date
    10-17-2016
    Location
    Sofia, Bul
    MS-Off Ver
    2010
    Posts
    5

    excel chart multi level axis remove separators

    Is there a way to remove separators on excel charts with multi level axis. For example in the horizontal axis on the following chart:

    Untitled.png
    I don't want separate line between (1;1),(4,2) et.c also is it possbile to skip every second couple(4;2),(16;4)
    Last edited by Vladimir.Yanakiev; 10-18-2016 at 07:14 AM.

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

    Re: excel chart multi level axis remove separators

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to Quick Post button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson

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

    Re: excel chart multi level axis remove separators

    uncheck multi level and set interval between labels to 2
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    10-17-2016
    Location
    Sofia, Bul
    MS-Off Ver
    2010
    Posts
    5

    Re: excel chart multi level axis remove separators

    @protonLeah I will have in my mind next time.

  5. #5
    Registered User
    Join Date
    10-17-2016
    Location
    Sofia, Bul
    MS-Off Ver
    2010
    Posts
    5

    Re: excel chart multi level axis remove separators

    @Andy Pope thankue for your answer

+ 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. Chart Multi-level category problem
    By sammaes in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-23-2016, 08:03 AM
  2. Changing chart type & second axis on chart with 2-level axis labels
    By trolle in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-15-2016, 09:52 AM
  3. Multi-level bar chart: is it possible? how?
    By s0050506 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-09-2014, 02:12 PM
  4. Managing Multi level X axis
    By aneesh_kotwal in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-14-2013, 12:27 AM
  5. Graph X axis (multi-level category labels) not showing all the text
    By mclhone in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-05-2013, 09:33 PM
  6. formatting a multi-level catagory axis label???
    By nmoore5 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-17-2013, 03:04 AM
  7. [SOLVED] I need separators on the X axis of a chart.
    By Frank Martin in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-03-2006, 08:35 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