Anyone good with Excel?

bugle25

Banned
Nov 23, 2005
176
0
0
Need to write a couple of graphs. However, I want to start at 0 with the data, not 1. How do you alter the axis's?
 

Caesar

Golden Member
Nov 5, 1999
1,686
178
106
Originally posted by: bugle25
Need to write a couple of graphs. However, I want to start at 0 with the data, not 1. How do you alter the axis's?

Right click on the axis and "Format axis". I don't know if you ARE asking for this cuz thats too simple. :confused:
 

IronWing

No Lifer
Jul 20, 2001
72,348
32,904
136
Make the chart. Click on the x axis. Use the other mouse button and select format axis, select the Scale tab, unclick auto minimum and enter 0. Repeat for y axis.
 

bugle25

Banned
Nov 23, 2005
176
0
0
Got it to work using what you said. Thanks. I don't ever use Excel, usually graph paper and pencil. lol
 

IronWing

No Lifer
Jul 20, 2001
72,348
32,904
136
Originally posted by: JulesMaximus
Thought you might be asking for help with vlookups or something.

I just learned to use vlookups a couple weeks ago, cool stuff! Just after I learned about named cells and named ranges, even cooler. For years I had been using $A$23 type notation but named cells are so much better.