+ Reply to Thread
Results 1 to 5 of 5

Chart Week of year by reporting date

  1. #1
    Forum Contributor
    Join Date
    06-20-2007
    Location
    Buckeye, AZ
    MS-Off Ver
    365
    Posts
    274

    Chart Week of year by reporting date

    In the attached workbook I'm trying to chart the variation in weeks (column B) by reporting date (Row 2). For example, week 10, beginning on reporting date 3/12 is 78%. As reporting dates progress the percentage changes to 72, 74, 77, and 77. this is expected but needs to be tracked. Everything I try keeps returning the reporting date total.
    Any help is greatly appreciated!
    Sick
    Attached Files Attached Files
    Last edited by sick stigma; 04-10-2024 at 10:20 AM.

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Chart Week of year by reporting date

    Hi there,

    I've probably completely misunderstood what you require, but does the attached version of your workbook get you moving in the right direction?

    Regards,

    Greg M
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    06-20-2007
    Location
    Buckeye, AZ
    MS-Off Ver
    365
    Posts
    274

    Re: Chart Week of year by reporting date

    Frankly, I"m not sure. Ideally, I would like to see each week (column B) chart left to right by Reporting Date (Row 2) displaying each individual percentage.
    Like this, but all in one chart
    Attached Files Attached Files
    Last edited by sick stigma; 04-09-2024 at 12:36 PM.

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Chart Week of year by reporting date

    Hi again,

    Take a look at the attached version of your latest workbook and see if things are moving in the right direction. From the previous version I thought you were interested in tracking data rows, but this version tracks data columns instead.

    Values in the range A4:A23 will update automatically as data for future weeks are added, and the graph is populated from this range.

    Hope this helps.

    Regards,

    Greg M
    Attached Files Attached Files

  5. #5
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Chart Week of year by reporting date

    Post deleted.

    Greg M

+ 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. [SOLVED] Updating week number, start date of the week, and year from a column date that's populated
    By Raylou in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-28-2020, 11:11 AM
  2. Replies: 5
    Last Post: 04-11-2017, 09:23 AM
  3. [SOLVED] Get the date of saturday in a week from a week number / year
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2015, 06:56 PM
  4. [SOLVED] Date Formula to Return Week Number in Current Month based on Reporting Period
    By jeversf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2013, 12:10 PM
  5. Replies: 3
    Last Post: 08-14-2009, 04:07 AM
  6. Replies: 0
    Last Post: 11-28-2007, 07:00 AM
  7. [SOLVED] Calculating a Date Based on Year, Week Number and Day of the Week
    By amy in forum Tips and Tutorials
    Replies: 1
    Last Post: 08-23-2005, 11:42 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