How to get Vertical reference lines parallel to Y axis ?

[montubhardwaj]

Hi folks,

I am having little problem displaying Reference lines parallel to Y axis. Here is the description:

I have a filed "Month" which holds data for 3 years (in format like Jan-10 through Dec-10,Jan-09 through Dec-09,Jan-11-Dec-11).I want to plot expression (say Sum(Sales)) against this dimension and it is working all fine. Now I want to have reference lines at the end of each year i.e. on Dec-09, and Dec-10 . The "Month" field in not a calculated dimension and is directly from DB.

I have attched the sample layout below.Need your suggestions.

[montubhardwaj]

Hi Linda.... I didnt get you..... do you mean that you are not able make any selections on your dimension ? please attach sample doc ....

Regards,

Dinesh Sharma

[jonathandienst]

Linda

I am not sure of your meaning, but if you mean that you can't get vertical reference lines, then remember that the X-axis must be continuous. Go to Axes and check the "Continuous" option for the Dimension axis.

Jonathan

[lmonincx]

Hi Jonathan,

That was the issue, I had to place the Continuous Option, Many Thanks!

Linda