Excel Help!!

Reply Subscribe

Thread Tools

Nov 4, 2004 | 08:03 PM

TypeSAddict

Thread Starter

is Pretty Much a Moron

Joined: Oct 2001

Posts: 8,140

Likes: 2

From: Rochester, NY

Excel Help!!

Okay I need to make a line graph in Excel. I've got the entire thing done except I can't figure out how to change the values on the X-Axis! It won't change from 1, 2, 3, 4, 5, .... etc. I need it to be 0, 20, 40, 60, 80 ... 200. HELP!! Thanks.

Nov 4, 2004 | 08:05 PM

JarodL

Banned

Joined: Apr 2001

Posts: 1,231

Likes: 0

From: Manhattan

right click on the axis and then click format axis i believe.

Nov 5, 2004 | 12:58 AM

Casper42

04 TL 6MT NAVI ABP/Q

Joined: May 2004

Posts: 1,314

Likes: 0

From: Simi Valley, CA 805

Right click on the edge or back o the chart.
Something about source data
X Axis Labels

Nov 5, 2004 | 01:32 AM

ccannizz11

My Work is Done Here

Joined: Jun 2004

Posts: 11,134

Likes: 2

From: Still too far from the beach

Simple.....

Instead of using the line graph, use the XY scatter graph and add a trendline. This allows you more room to play when you format the x-axis