+ Reply to Thread
Results 1 to 4 of 4

charting yearly data from a list of several years of data

  1. #1
    Registered User
    Join Date
    05-19-2022
    Location
    usa
    MS-Off Ver
    ohio
    Posts
    2

    charting yearly data from a list of several years of data

    I have a data set that includes four columns and a hundred rows. A is date. B is group 1. C is group 2. And D is group 3. The A column is dates from January 1, 2020 to May 1, 2022 and is continuously updated with new rows. I'd like a line chart chart to show how the three groups change over time within their respective year. So the horizontal axis would be january 1 to december 31. The vertical axis would be dollars. I'd like to see how the three groups change month to month, on top of each other. Like I'd like to see if the trend of those groups over the course of a year is the same for every year. How would I go about that?

    I can easily chart it from the beginning to the end, but then I have to look at the data points for january of 2022 then go way back to the beginning on the line for january 2020. I'd like to see the data for all the january's on top of each other.
    Attached Files Attached Files
    Last edited by jermmcdowell; 05-19-2022 at 12:32 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: charting yearly data from a list of several years of data

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    05-19-2022
    Location
    usa
    MS-Off Ver
    ohio
    Posts
    2

    Re: charting yearly data from a list of several years of data

    Quote Originally Posted by alansidman View Post
    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    done, sorry

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

    Re: charting yearly data from a list of several years of data

    Hello
    Try putting the dates in the first column, the values ​​of the year 2021 in the second column and those of the year 2022 in the third.
    Take a look at the attachment as an example for the first series only.
    Hello,
    Mario
    Attached Files Attached Files

+ 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 not charting data picked by List Box
    By e602043 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-28-2016, 12:23 PM
  2. Forecasting with set yearly average and 4 years of monthly data
    By Litkin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-02-2016, 11:27 AM
  3. Replies: 1
    Last Post: 04-17-2009, 04:57 AM
  4. [SOLVED] Uniquely Identify Data for Charting with a List Box
    By Takeadoe in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-15-2006, 05:20 PM
  5. Replies: 0
    Last Post: 07-15-2006, 02:45 PM
  6. [SOLVED] how can list data weekly,monthly yearly etc in ms excell
    By Abdul Gaphoor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2006, 01:40 PM
  7. [SOLVED] sales data how i can list weekly,monthly yearly etc..etc...
    By Abdul Gaphoor in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-01-2006, 07:20 AM

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