ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Mirror/Flip Axis/Chart (https://www.excelbanter.com/charts-charting-excel/53462-mirror-flip-axis-chart.html)

oberon.black

Mirror/Flip Axis/Chart
 

I have a chart in excel that I want to display the 'y' axis on the right
side and the 'x' axis to read from right to left.

How can I do this?


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=481011


Jon Peltier

Mirror/Flip Axis/Chart
 
Double click on the X axis, and on the Scale tab, check the Categories
in Reverse Order box. The Y axis will switch sides at the same time the
categories reverse.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


oberon.black wrote:

I have a chart in excel that I want to display the 'y' axis on the right
side and the 'x' axis to read from right to left.

How can I do this?




All times are GMT +1. The time now is 05:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com