+ Reply to Thread
Results 1 to 4 of 4

Graphing using Quarters/Years

  1. #1
    Registered User
    Join Date
    05-13-2020
    Location
    California
    MS-Off Ver
    2016
    Posts
    2

    Graphing using Quarters/Years

    Hello,

    I'm drawing a blank on how to make this easy. I'm trying to track sales for 5 different product types by quarter.

    I have the sheet laid out like this.
    Column
    A - Product
    B - Quarter
    C - Year
    D - Sales

    I want each product type to have a separate line.

    Seems easy but I can't get it to work.

    Capture.PNG

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Graphing using Quarters/Years

    You can use Pivot table for that.

    If you add an excel file, I will make an example for you.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    05-13-2020
    Location
    California
    MS-Off Ver
    2016
    Posts
    2

    Re: Graphing using Quarters/Years

    Thank you!
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Graphing using Quarters/Years

    I made an example of a pivot table.

    Maybe you need to analyse other data.

    Or you want to change the lay out.

    See the attached file, to get you started.

+ 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. Months to quarters to years
    By miumamou in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-08-2019, 09:03 AM
  2. Calculating Rolling Sum based on quarters & years
    By Stathissp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2018, 10:53 AM
  3. Replies: 2
    Last Post: 01-29-2018, 02:51 AM
  4. Auto Populate quarters by just typing in the number of years
    By sugar_lips in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-27-2014, 09:31 AM
  5. [SOLVED] Excel 2010 - Time between dates in years and quarters (.25)
    By undergrads in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-18-2013, 02:16 AM
  6. Graphing Quarters
    By bluerog in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-28-2011, 11:04 AM
  7. Show quarters and years on x axis of a chart
    By Kacee in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-19-2005, 12:06 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