How can I change Chart.Axes(xlValue) from left side to right side ?

Greetings,
1- Open enclosed file.
2- Run Macro1.

Please Login or Register  to view this content.

3- See that there is a chart on the Sheet1.
4- Look at "question sheet" in order to understand my question.

Regards.

In VBA, you will use the .crosses property of the horizontal axis to specify that the vertical axis should cross the horizontal axis at the maximum category.

http://msdn.microsoft.com/en-us/libr...ice.14%29.aspx

Thanks for the link...
But I dont understand how I can make it works...
Some support please...

Start with the sample statement from the help file:

Please Login or Register  to view this content.

Naturally, using activechart means this statement will need to occur after the chart has been created and selected, which your current code is already doing.