Forum Discussion
Monthly data spanning over a year
Hi All,
I am very new to this, less than a week...I have tried searching and not sure if I am getting the right terminology. I am trying to replicate this powerpoint slide
However, it turns out like
Behind the scenes this is the data that I have in a excel file.
Thanks in advance for any help.
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:
3 Replies
SeanCommunity Champion
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.
- Sean
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:
