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.
As a mildly dirty workaround, you could use 09
as your week number - then string ordering will do what you need.
[OT] sorry this is not an answer, but could you tell me how to display values above the columns charts? thankyou so much!
In the chart's format menu's general tab, turn on "show data values".
As a mildly dirty workaround, you could use 09
as your week number - then string ordering will do what you need.
Thank you Martin, Appending zero did the trick. Wish there was a better way to do this though. Cheers!