cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LouisCareme Frequent Visitor
Frequent Visitor

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 :

 

photo.PNG

 

 

 

 

 

 

 

 

 

 

 

 

My problem is that I cant do beautiful graphs following months

I only get things like that :

 

degueu.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Can someone explain me how I can get good graphs ?

 

Thanks 

 

PS : Sorry for my bad english

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Make graphs with strange data

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


2 REPLIES 2
Super User
Super User

Re: Make graphs with strange data

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


LouisCareme Frequent Visitor
Frequent Visitor

Re: Make graphs with strange data

Perfect, thanks for your help!