+ Reply to Thread
Results 1 to 4 of 4

Additional Year does not Show on Graph

  1. 06-05-2023, 07:53 AM #1
    AllisterB
    AllisterB is offline
    Forum Contributor
    Join Date
    07-10-2020
    Location
    New Zealand
    MS-Off Ver
    365 personal
    Posts
    302

    Additional Year does not Show on Graph

    Hi

    I have a Line Graph for 2020 thru 2022. I have added 2023 and updated the Data Sries to include 2023 but 2023 data or label does not show on the graph.

    How can I fix this.

    Thank You

    Allister
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-05-2023, 07:59 AM #2
    AliGW
    AliGW is online now
    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. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Additional Year does not Show on Graph

    You haven't updated the series in the chart data.

    Select Data - edit legend series - change the values range to this: =Sheet1!$E$5:$H$5
    Attached Files Attached Files
    Last edited by AliGW; 06-05-2023 at 08:01 AM.
    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.
    Reply With QuoteRegister To Reply
  3. 06-05-2023, 08:20 AM #3
    AllisterB
    AllisterB is offline
    Forum Contributor
    Join Date
    07-10-2020
    Location
    New Zealand
    MS-Off Ver
    365 personal
    Posts
    302

    Re: Additional Year does not Show on Graph

    Thanks ALiGW

    That was easy :-)


    Allister
    Reply With QuoteRegister To Reply
  4. 06-05-2023, 08:21 AM #4
    AliGW
    AliGW is online now
    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. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Additional Year does not Show on Graph

    Glad to have helped.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Additional Charge on Incremental Year
    By josephteh in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-11-2022, 06:05 AM
  2. [SOLVED] cbbox that will dynamically show current year month and year
    By pb21uk in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-19-2022, 05:32 AM
  3. [SOLVED] Drop Down list showing current month & year and formula to show Prev Year
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-30-2020, 11:54 PM
  4. Graph showing additional dates
    By antony moseley in forum Excel General
    Replies: 9
    Last Post: 11-27-2017, 12:50 PM
  5. How can I show Year to Date orders from previous year quickly?
    By CenterShock in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-02-2015, 05:26 PM
  6. [SOLVED] Graph Will Not Show Additional Months Data?
    By garrett.grillo in forum Excel General
    Replies: 8
    Last Post: 03-26-2014, 01:25 AM
  7. Compare values year to year in a line graph
    By Purdue02 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-04-2005, 02:28 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1