I want to get the line chart as attached such as
month in x axis
year in Y axis
Calculated Measure(MA_Cf)
The problem is that when doing as per the below steps i am getting Year and the measure in legend area.When i need to get the year in the Y axis.
1) I have taken months column on X-axis
2) I selected the chart and I set Y2 Axis property to Show
3) I dropped Year column in series and I selected the year and I set Axis Assignment property to Y Axis 2 Axis
4) I dropped the MA_CF above the Year in the series dropzone
But my problem is year values I am getting rightside(as legend), these are not displaying in the Y axis 1 and MA_CF is displaying at righthandside as label (like legend) , ,
Can anybody help me out inthis there are any settings we need to do to get the chart as it is in attachments.
(//)ftp://
Hi,
I can't see your attachment - just a missing image placeholder.
can any one tell that how to attach the document