How you create bar chart for months and labels

[Anonymous]

Maybe this is too simple question but I am trying to create a bar graph for the following data. The rows(name of the header Measured stat per month) and col are the represent the months. The bar graph should have the on X axis months and and Y should be the Measured col but the Measured in the data is turn to count which I do not want to be a count or distunct count

 

[parry2k]

@Anonymous it auto-generates the scale, I don't think there is an option to set the scale increments.

[Anonymous]

@parry2k Thank you so much I appreciate your help. I think I found the solution to my problem by unpivoting the table like this which results in this chart. My only thing now is that I am now trying to change the increaments of the Y axis

[parry2k]

@Anonymous still does not agree with that approach and wrap my head around the expectation. I think the table visual is the best visual here.

[parry2k]

@Anonymous I don't think a bar chart is the right visual for what you are trying to achieve, what will the bar represent if it is a text?

[Anonymous]

I am picturing a graph that show for each moth the label from Measure stat 

[parry2k]

@Anonymous as I mentioned previously you will not able to see text columns on the y-axis. I guess I was not clear in my previous reply.

[Anonymous]

Yes, thank you I understood that! given the data above how would you creat bar chart from them? Any sugestion? 

[parry2k]

@Anonymous unfortunately you cannot use text column on Y-Axis, it has to be some number column with aggregation, and if it is text (in your case), it uses count as aggregation.

[Anonymous]

I unpivot but this still did not reolve the issue. I was thinking to create a table out of the months and Measured to be the Y. But maybe I am doing something wrong. Any sugestion how to do this