How to show just 1 vertical minor gridline on x axis in XY scatter plot

hello,

i'm using sql 2008

i have xy scatter plot x axis (category axis) percentages, scalar values 5%, 10%, 15%, 20 %.

i succesfully added horizontal target value line on y-axis.

i'm trying add vertical line target x-axis value, e.g. 14%. enabled minor grid lines on x-axis, , tried make 1 line visible based on visibility expression. it's not working.

are there better ways create vertical target value line, or doing wrong?

 

regards, hennie

 

hi hennie,

 

generally, adding vertical line x-axis infrequent requirement, there 2 workarounds it, detailed steps please following these:

 

>>method one: adding major gridline interval e.g. 0.14 scatter chart

 

1.      right-click scatter chart area’s gridline , select major gridline properties…

2.      set value of grid interval 0.14 line width 1pt line color black

note: method not common workaround suit special requirement, has limitations:

1)you have set line width 1pt line color black, y-axis have same layout major gridline.

2)the maximum of value on x-axis must less interval*2, otherwise there more 1 major gridline.

below picture report designed following top method:

    

 

>>method two: drag line control scatter line directly. lay @ place like, flexible. however, method still have limitation, value on x-axis must fixed, line’s location fixed.

 

if have question, please feel free ask.

 

regards,

challen fu

SQL Server  >  SQL Server Reporting Services, Power View