Forum Discussion
Monthly data spanning over a year
Beiffon Okay first the easy and fast way to do this :smileyhappy:
1) Drag the Month column to the axis
this should create a Hierarchy click the x next to Quarter and Day to keep just Year and Month
2) Then click the Expand All on the chart
3) and finally you may have to sort it by clicking in the upper right corner
This should do it!
Good Luck! :smileyhappy:
Beiffon Okay first the easy and fast way to do this :smileyhappy:
1) Drag the Month column to the axis
this should create a Hierarchy click the x next to Quarter and Day to keep just Year and Month
2) Then click the Expand All on the chart
3) and finally you may have to sort it by clicking in the upper right corner
This should do it!
Good Luck! :smileyhappy:
Thankyou so very much.
If you do want to get exactly the same result as in your picture
1) Create a New Column
2) say MMM-YY=FORMAT(Table[Month], "MMM-YY") as in the picture
3) then select this new column and click the Sort By Column button and 4) select the Month column from the dropdown
(otherwise if you it leave at the default it will sort alphabetically)
Then create your chart using the new MMM-YY column for the Axis
Now you can get exactly the same result - whether its worth the extra step - that's up to you!
Good Luck! :smileyhappy: