+ Reply to Thread
Results 1 to 4 of 4

Show week numbers

  1. #1
    Registered User
    Join Date
    06-17-2019
    Location
    Denmark
    MS-Off Ver
    2016
    Posts
    15

    Show week numbers

    Hi

    How can I make excel show week numbers for data points (graphically) in a pivot table? It knows the dates

    Thanks in advance!

  2. #2
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    696

    Re: Show week numbers

    Considering the fact that grouping of date is not there in pivot table, we suggest you to go with an additional column to write down the week numbers
    Use the formula:
    ="Week "&WEEKNUM(A2)
    Where A2= Date
    Once the above done, use Pivot Table and drag down the week number to Row Label and amount to Values. After that Insert a Pivot Chart

  3. #3
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Show week numbers

    Shareez idea is the best one, but if is not possible for you to add a helper column, then try some pivot grouping: https://www.contextures.com/xlPivot07.html
    Click the * to say thanks.

  4. #4
    Registered User
    Join Date
    06-17-2019
    Location
    Denmark
    MS-Off Ver
    2016
    Posts
    15

    Re: Show week numbers

    Thank you. It made the week start on a Sunday, though, but I found out how to make it use the European week numbering system (one can wonder why a Danish version of Excel doesn't use the European system as a matter of default, but oh well... :P)

+ 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. Help with Pivot - Need to get current week and next week numbers
    By Beso90 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-26-2019, 03:54 PM
  2. [SOLVED] Count Week numbers given start and finish week number
    By Vassen in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-30-2016, 01:59 AM
  3. [SOLVED] Conditional Formatting to show week over week improvement/decline
    By erikw48 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-15-2015, 10:22 AM
  4. Replies: 8
    Last Post: 06-28-2014, 03:26 PM
  5. Show day of the week
    By aisa313 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-11-2012, 02:06 PM
  6. Show Start of Week End of Week
    By djblois1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-13-2012, 12:31 PM
  7. Always Show Week Beginning or Week Wending
    By mycon73 in forum Excel General
    Replies: 3
    Last Post: 10-18-2010, 03:26 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1