Hello, I have a chart that shows percentages on the left y-axis which are MTD performances and Value in the right(secondary) y-axis which show the growth of 1000 dollars according to the MTDs. When I set the Cross At property in on the left y-axis it works as expected. But when I set it on the right axis it doesn't cross it at the desired value (1000 in my case). This is the best I could do : http://imageshack.us/photo/my-images/109/observed.jpg/ And this is the chart I want to achieve: http://imageshack.us/photo/my-images/845/desired.jpg/

Hi Dimitar, Thanks for your post. Based on the information and snapshots you provided, you would like to use cross at property to control the bars display either upward or downward, just as you expected, it works. While the Value in the right (secondary) y-axis which shows as a Line chart type, looks like nothing changes. The line chart’s appearance due to the fluctuation of data values (growth of 1000), because each value was represent as a point instead of bar actually, nevertheless you change the cross at value to 1000, it still looks like nothing changes. Moreover, the difference between the two snapshots you provided is the fluctuation of data values (growth of 1000), so if you want to achieve the big fluctuation line chart, please enhance the value contrast of the neighbor values. If you have anything unclear, please feel free to let me know. Thanks, Bill LuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.