Forum Discussion
Make graphs with strange data
Hi everyone,
I have a problem with my graphs...
My dataset is composed by months in columns as you can see here :
My problem is that I cant do beautiful graphs following months
I only get things like that :
Can someone explain me how I can get good graphs ?
Thanks
PS : Sorry for my bad english
Well, that is going to depend on what your definition of good is. What are you trying to display? But, I would try switching your X-Axis with your Legend so that your months are in the axis and your people are the legend. That might be a start. To do this, you will want to Unpivot your month columns in Power Query.
2 Replies
Well, that is going to depend on what your definition of good is. What are you trying to display? But, I would try switching your X-Axis with your Legend so that your months are in the axis and your people are the legend. That might be a start. To do this, you will want to Unpivot your month columns in Power Query.