ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Graphs Axes Location (https://www.excelbanter.com/excel-worksheet-functions/206791-graphs-axes-location.html)

srm

Graphs Axes Location
 
I'm using E2003. I received a Word document that had a stack bar chart
with the "Y" values at the top of the graph (not on the bottom). I
cannot see how to do this in Excel. Once the graph is in Word, I can
drag the "Y" values to the top, but cannot seem to locate this option
in Excel (moving the "Y" values to the top of the graph). He said he
did it in Excel but cannot locate this function.

Can you move the "Y" values from the bottom of the graph to the top in
Excel?

Thank you

srm

ShaneDevenshire

Graphs Axes Location
 
Hi

The axis at the top or bottom is the X axis.

To move the X-axis to the top is to double-click the Y-axis on the left side
of the chart, and on the Scale tab check Values in reverse order.

this may be what they used or they may have gotten fancier. Check it out
and see if it meets your needs.

--
Thanks,
Shane Devenshire


"srm" wrote:

I'm using E2003. I received a Word document that had a stack bar chart
with the "Y" values at the top of the graph (not on the bottom). I
cannot see how to do this in Excel. Once the graph is in Word, I can
drag the "Y" values to the top, but cannot seem to locate this option
in Excel (moving the "Y" values to the top of the graph). He said he
did it in Excel but cannot locate this function.

Can you move the "Y" values from the bottom of the graph to the top in
Excel?

Thank you

srm


ShaneDevenshire

Graphs Axes Location
 
Hi,

See your other post.
--
Thanks,
Shane Devenshire


"srm" wrote:

I'm using E2003. I received a Word document that had a stack bar chart
with the "Y" values at the top of the graph (not on the bottom). I
cannot see how to do this in Excel. Once the graph is in Word, I can
drag the "Y" values to the top, but cannot seem to locate this option
in Excel (moving the "Y" values to the top of the graph). He said he
did it in Excel but cannot locate this function.

Can you move the "Y" values from the bottom of the graph to the top in
Excel?

Thank you

srm



All times are GMT +1. The time now is 01:00 AM.

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