Hi all,
I have a pivot table where I group by week number and year to show weekly totals of cycling ride data for each week of each year, with a chart to show comparison of the data. I have just noticed that for the past 3 weeks this year I have entered, the week number sort order is out of sequence, and this is reflected in the chart. Weeks 1-38 are in correct sort order, then it goes 44-46 then 39-43. The week number is taken from cells that use the "WEEKNUM" function, and this is showing the correct value for week number in the appropriate cell for each row of entered ride data.
How can I get the sort order to display correctly?
I have a screenshot with highlight showing the problem weeks in the table and chart, but can't work out how to attach it to this post (I tried the "Insert Image" button but it requires a URL to the pic - I have no website to post it to). I can provide the screenshot if you can advise me how to attach it).
PS. I also have other tables and charts that group by month, and these show correct sort order in the table but the chart sorts with December at the top and January at the bottom - is there a way to fix this? I have not been able to work out a way to do this.
Thanks in advance,
Mick McKean
I have a pivot table where I group by week number and year to show weekly totals of cycling ride data for each week of each year, with a chart to show comparison of the data. I have just noticed that for the past 3 weeks this year I have entered, the week number sort order is out of sequence, and this is reflected in the chart. Weeks 1-38 are in correct sort order, then it goes 44-46 then 39-43. The week number is taken from cells that use the "WEEKNUM" function, and this is showing the correct value for week number in the appropriate cell for each row of entered ride data.
How can I get the sort order to display correctly?
I have a screenshot with highlight showing the problem weeks in the table and chart, but can't work out how to attach it to this post (I tried the "Insert Image" button but it requires a URL to the pic - I have no website to post it to). I can provide the screenshot if you can advise me how to attach it).
PS. I also have other tables and charts that group by month, and these show correct sort order in the table but the chart sorts with December at the top and January at the bottom - is there a way to fix this? I have not been able to work out a way to do this.
Thanks in advance,
Mick McKean