Thanks for the quick reply, The solution for first problem works good. But for second, by Axis I mean the grey color border which is appearing with the chart I want the right border to be invisible
file:///C:/DOCUME%7E1/ankohli/LOCALS%7E1/Temp/msohtml1/01/clip_image002.gif