How to sort columns in chart with row-split

[lem]

Hi,

I need to graph data per Area split by WeekNumber:

| chart Values by Area WeekNumber
Both - Values and WeekNuber are numbers, however WeekNmubers in the graph are sorted as if they are string type ( 10, 11, 9 instead of 9, 10, 11).

If I swap series:
| chart Values by WeekNuber Area
the WeekNumbers are sorted correctly on X-Axis (9, 10, 11).

I tried using "sort WeekNumber" and didn't have any impact on column order.

Any help is greatly appreciated.

[mikymasterlace]

[OT] sorry this is not an answer, but could you tell me how to display values above the columns charts? thankyou so much!

[martin_mueller]

In the chart's format menu's general tab, turn on "show data values".

[martin_mueller · Accepted solution]

As a mildly dirty workaround, you could use 09 as your week number - then string ordering will do what you need.

[lem]

Thank you Martin, Appending zero did the trick. Wish there was a better way to do this though. Cheers!