What can I do to change the numbers on the x-axis in Microsoft Excel 2007?

for a lab report in biology class, I have to make a graph. i know how to change the numbers on the y-axis, but the numbers on the x-axis remain as 1, 2, 3, etc. I want them to change to 0-5, 15-25, 30-35 etc. How do I do this? Thank you for your help.

Become an Expert →

Answer #1

Select the axis values you want to format. Click the x-axis or y-axis directly in the chart or click the Chart Elements button (in the Current Selection group of the Format tab) and then click Horizontal (Category) Axis (for the x-axis) or Vertical (Value) Axis (for the y-axis) on its drop-down list. Be sure to select the axis values, not the axis title. Excel surrounds the axis you select with selection handles.

Click the Format Selection button in the Current Selection group of the Format tab.

Change the appropriate options on the Axis Options tab as needed.

Click the Number tab and change the number formatting as needed.

Click the Alignment tab and adjust how the labels appear. Indicate the new orientation by clicking the desired vertical alignment in the Vertical Alignment drop-down list box and desired text direction in the Text Direction drop-down list.

More Like This

Do I need to change the type of Microsoft word if I have Microsoft 2003 and my school has Microsoft 2007? - 2 Answers
I have a few documents that I need to print and the file type is Microsoft 2003 and I'd like to print the documents at school...
What is the purpose of microsoft excel ? - 3 Answers
Hi, What is the purpose of microsoft excel ?? , I need a short but detailed description x
Microsoft Powerpoint 2007 - 1 Answers
I just bought microsoft powerpoint 2007. How do you make your text fade in when you switch it. (not JUST fade in there are...
Change my imei number - 1 Answers
How can I change imei number on tocco phone For free ?
Microsoft office word 2007 not in english - 2 Answers
I just downloaded microsoft office word 2007 and it is not in english!! Could somebody give me the steps in great detail, bec...
What is the difference b/w Microsoft Works 9 & Home & Student 2007? - 1 Answers
I'm buying a laptop for school soon and could have either Microsoft Works 9 or Microsoft Home and Student 2007 with Word, Exc...
change my phone number on my sidekick lx? - 1 Answers
How do I change my phone number on my sidekick lx?
change numbers and cell phones? - 2 Answers
I have a verizon flip phone its nothing special but yesterday my brother gave me his old phone it is an envy 1 and I want to ...
How do find the phone number on my wifes phone she had it changed"? - 3 Answers
Need help finding phone number don,t know how it.s a boost phone but they will let her know if I try trhough them
Microsoft Excel HELP! - 1 Answers
Well, my science coursework has to be in for tomorrow :P and I've left it till last minute (as usual) I was just wondering is...

Ask an advisor one-on-one!

What can I do to change the numbers on the x-axis in Microsoft Excel 2007?

Microsoft Việt Nam - Internet...

Serial Number Full

KBC Helpline Number

Reckon Support Number Australia

Excellence Technology