ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Is there a way for the x axis in an excel chart to be at the top (https://www.excelbanter.com/charts-charting-excel/26981-there-way-x-axis-excel-chart-top.html)

ddbusch

Is there a way for the x axis in an excel chart to be at the top
 


Bernard Liengme

Yes, double click the axis, open format menu
Specify where the axis is to cut the y-axis. Suppose your max y-axis value
is 12, then use this as the place for the x-axis to cut the y-axis.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ddbusch" wrote in message
...




Jon Peltier

But remember, where the X axis crosses the Y axis is a property of the Y
axis, so you have to double click the Y axis.

There's also a checkbox in the Y axis format scale dialog, X Axis
Crosses at Maximum Value, which you could check to lock the position.

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


Bernard Liengme wrote:

Yes, double click the axis, open format menu
Specify where the axis is to cut the y-axis. Suppose your max y-axis value
is 12, then use this as the place for the x-axis to cut the y-axis.
best wishes



All times are GMT +1. The time now is 02:21 AM.

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