Change the axis

[iliaisyah]

Hai and good afternoon,

enclosed is the graph that i have.

how can i change my Y axis to X axis. 

I wish to have month to X axis and Elements in Axis Y.

But the expression is the monthly yield per area basis 

the graphs is Location Yield per area

[anushree1]

Hi, 

I am not sure if this is the answer you are looking for, whatever you put up on Dimension Tab of a chart becomes your X Axis and the Expression your Y Axis , if you have added Month as Dimension in Dimension Tab you should already be seeing it on X: Axis, Please provide the sample qvw if you are looking for something in specific.

[iliaisyah]

it didnt work

if in excel it will look like in the excel

my data compilation as attached

[anushree1]

It can be done as per this solution.

[iliaisyah]

i have open the file

is they other way that i can use just from the chart function and not the editting the script?

[anushree1]

You could also try this method as its much cleaner than the previous solution provided

[anushree1 · Accepted solution]

Well you may skip the group by and sum , but concatenate and as keyword are essential,like the attached