Graph Data Order

[Anonymous]

I have a table containing, Year, and WeekNumber in two columns the data, WeeklyPercentage, and  a sorting column Sort.

I want to display the data on a graph with year and week number along x axis, WeeklyPercentage on the y axis and EscatlationLevel as the legend.

The graph always displays with the sorted by the WeeklyPercentage descending (sorted by y axis rather than x axis). I want to display with the x axis sorted

I have added the Sort column, but if I try and sort the WeeklyPercentage columns (contains duplicates) by this Sort column (doesn't contain duplicates) I get the following error.

How do I display with the X axis is sorted by Year and then WeekNo?

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may try to use 'Sort by' as below picture.

Regards,

Cherie

[Anonymous]

That seems to have sorted it. So Simple when you know how!

[rocky09]

can you add some sample data. So, I can try.