Hi
How can I make excel show week numbers for data points (graphically) in a pivot table? It knows the dates
Thanks in advance!
Hi
How can I make excel show week numbers for data points (graphically) in a pivot table? It knows the dates
Thanks in advance!
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
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.
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks