Forum Discussion
Basic graph with data on rows (not in columns)
I think that to get the result that you want, you will have to unpivote the Month columns.
To do this you should choose Edit Queries on the Home tab.
Then got to the query in question and select all of the month columns.
Next, on the Transform tab choos Unpivote Columns.
Finally, hit close and apply.
Now you should be able to create the visual that you are looking for.
Is this what you were looking for?
Something like this?
Advocate IVI think that to get the result that you want, you will have to unpivote the Month columns.
To do this you should choose Edit Queries on the Home tab.
Then got to the query in question and select all of the month columns.
Next, on the Transform tab choos Unpivote Columns.
Finally, hit close and apply.
Now you should be able to create the visual that you are looking for.
Is this what you were looking for?
Something like this?
Yes thank you !! :)