Displaying two metrics (year and month) in y-axis in a line graph.

[#1]

Hi All,

I have 2 queries -

1. I want to display the year and month in the y axis in a line graph. I am able to do the same in a bar chart by creating a dummy in the expression field but its not working for the line chart.

2. I want to display the months in a proper interval. For eg - for all the years the month should show Jan,Jun, Sep & Dec. This is something which we can do in excel. I am not sure how to do it on QV.

I have attached the format in which i want the graph.

Can some one help me out with this.

Thanks

Ani