+ Reply to Thread
Results 1 to 3 of 3

Grouping Dates by Year and Displaying Yearly Date as individual Line Graphs

  1. 07-25-2023, 01:30 PM #1
    sajeel
    sajeel is offline
    Registered User
    Join Date
    03-13-2009
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    98

    Grouping Dates by Year and Displaying Yearly Date as individual Line Graphs

    I have a set of data for which I have created a Pivot table, added some slicers to display data as a Line Graph.

    Currently it has dates on X Axis.

    I want to display data as different line graphs for each year on the same chart.

    I have attached my working sheet and an image of how I would like the data displayed
    Reply With QuoteRegister To Reply
  2. 07-25-2023, 01:39 PM #2
    sajeel
    sajeel is offline
    Registered User
    Join Date
    03-13-2009
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    98

    Re: Grouping Dates by Year and Displaying Yearly Date as individual Line Graphs

    Group by Year.PNG

    Tried attaching a file
    Reply With QuoteRegister To Reply
  3. 07-27-2023, 09:20 AM #3
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,570

    Re: Grouping Dates by Year and Displaying Yearly Date as individual Line Graphs

    Please try again to attach the file.
    If the .xlsx file size exceeds 1000 Kb then either reduce the amount of data (two years' worth should be sufficient) or try uploading as an .xlsb
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    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] Pivot Table Automatically Grouping Dates by Year, Quarter, Month etc
    By TheRobsterUK in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-19-2020, 07:42 AM
  2. [SOLVED] Forcast a Yearly Total Based upon Year-to-date Performance
    By selfevident1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-29-2016, 08:53 PM
  3. Match year of date to year of date specific range of dates, output corresponding value.
    By normilet in forum Excel General
    Replies: 1
    Last Post: 04-22-2015, 08:08 AM
  4. Moving average yearly, 6 month, 3 month, 1 monthand gives comparison using line graphs
    By jose_valooran in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-24-2013, 01:24 PM
  5. Formula to calculate the percentage of a year using a start date and year to date dates
    By pammy66 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-14-2012, 05:14 AM
  6. [SOLVED] PIVOT TABLES: Grouping dates by Fiscal Year, Quarter and Month
    By bimmer5dude in forum Excel General
    Replies: 5
    Last Post: 06-30-2012, 09:13 PM
  7. Line graphs with different dates
    By lpn in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-01-2009, 12:32 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