How to get week no serially in Stack Column Chart

[Anonymous]

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

[Ritaf1983 · Accepted solution]

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 :

Link to the sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly