Set the direction of the current worksheet
Press or release the Sheet Right-To-Left button.
On the Tools menu, click Options, click the International tab, and select or clear the View current sheet right-to-left check box.
Set the direction for new workbooks and worksheets
Click Right-To-Left to have new objects displayed in a direction familiar to right-to-left users.
Click Left-To-Right to have new objects displayed in a direction familiar to left-to-right users.
Change the direction of a chart
When right-to-left editing is enabled in Microsoft Excel, and the default orientation for new charts is right-to-left, charts are automatically configured with a right-to-left view. This means that the horizontal (category) axis origin and the vertical (value) axis appear to the right side of the chart, and the chart legend appears to the left of the chart.
You can manually move chart objects to a position that supports the direction you are trying to achieve