Forum Discussion
How to get week no serially in Stack Column Chart
Hello Team,
We have week no in our Excel file like this.
1, 2,3,4,5,6,7,8,9,10,11,12,13, 14 & and so on
when we put this week on the x-axis we are getting weeks like this
We want week no 1,2,3,4 like this
Thank you
Reagrds
VP2789
Hi Anonymous
You can solve this in one of 2 ways:
1. Change data type of week to whole number:And modify your X-axis as continuous :
The second option ( if you need a week to be a text ) , is just to sort your chart by week :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
1 Reply
Hi Anonymous
You can solve this in one of 2 ways:
1. Change data type of week to whole number:And modify your X-axis as continuous :
The second option ( if you need a week to be a text ) , is just to sort your chart by week :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly