+ Reply to Thread
Results 1 to 4 of 4

Series going outside of chart

  1. #1
    Registered User
    Join Date
    09-29-2023
    Location
    Lahore, Pakistan
    MS-Off Ver
    Excel 2021
    Posts
    2

    Series going outside of chart

    I'm having a problem with my charts where data (legend series) are having trouble adjusting to dates (horizontal series) and eventually fills cells outside of chart area. I have even tried to select specific series and date range instead of filtering in the side chart menu. Since this is my first post im not allowed to post any link, images
    Attached Files Attached Files
    Last edited by Everton2255; 09-29-2023 at 05:37 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,417

    Re: Series going outside of chart

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    09-03-2016
    Location
    Catania, Italy
    MS-Off Ver
    Excel 2019
    Posts
    164

    Re: Series going outside of chart

    HI
    If in your Charts you set the horizontal axis as Automatic instead of Fixed I think everything will be fine.
    Let me know.
    HI,
    Mario

  4. #4
    Registered User
    Join Date
    09-29-2023
    Location
    Lahore, Pakistan
    MS-Off Ver
    Excel 2021
    Posts
    2

    Re: Series going outside of chart

    Thanks for your response. I`ll check into it
    Last edited by Everton2255; 09-30-2023 at 05:09 AM.

+ 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. Replies: 0
    Last Post: 09-01-2021, 05:57 AM
  2. [SOLVED] Matching 'Chart Series title' to equation driven cells to set the series line colour
    By mattydboom1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-15-2020, 09:36 AM
  3. Replies: 2
    Last Post: 02-19-2017, 07:52 PM
  4. Delete Pivto Chart Series when certain word/text is found in the Series Name
    By trizzo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2016, 03:19 PM
  5. Chart front-to-back series display if series are different chart types
    By Exconomist in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-06-2012, 06:49 AM
  6. mixing column chart types for series and macro series?
    By riwiseuse in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-30-2010, 05:27 PM
  7. [SOLVED] chart data series -- plot a table as a single series
    By hjc in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 09-20-2005, 01: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