ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Altering the X-axis (https://www.excelbanter.com/charts-charting-excel/88503-altering-x-axis.html)

Maguire

Altering the X-axis
 

[image: http://img385.imageshack.us/img385/226/phgraph1uj.png]

I need help on a school project. I need to change the x-axis from 1-11
to 0-50.

Can anyone help me out here?

Thanks in advance.


--
Maguire
------------------------------------------------------------------------
Maguire's Profile: http://www.excelforum.com/member.php...o&userid=34409
View this thread: http://www.excelforum.com/showthread...hreadid=541865


Jon Peltier

Altering the X-axis
 
First step: change the chart to an XY chart, which has a true variable value
scale. Chart menu Chart Type.

Second step: double click on the new X axis, and set whatever scale
parameters you need.

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

"Maguire" wrote in
message ...

[image: http://img385.imageshack.us/img385/226/phgraph1uj.png]

I need help on a school project. I need to change the x-axis from 1-11
to 0-50.

Can anyone help me out here?

Thanks in advance.


--
Maguire
------------------------------------------------------------------------
Maguire's Profile:
http://www.excelforum.com/member.php...o&userid=34409
View this thread: http://www.excelforum.com/showthread...hreadid=541865




Maguire

Altering the X-axis
 

Awesome, thanks for the help.


--
Maguire
------------------------------------------------------------------------
Maguire's Profile: http://www.excelforum.com/member.php...o&userid=34409
View this thread: http://www.excelforum.com/showthread...hreadid=541865



All times are GMT +1. The time now is 11:37 AM.

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