Technology Get the latest on technology, electronics and software…

Excel Help!!

Thread Tools
 
Old Nov 4, 2004 | 08:03 PM
  #1  
TypeSAddict's Avatar
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.
Reply
Old Nov 4, 2004 | 08:05 PM
  #2  
JarodL's Avatar
Banned
 
Joined: Apr 2001
Posts: 1,231
Likes: 0
From: Manhattan
right click on the axis and then click format axis i believe.
Reply
Old Nov 5, 2004 | 12:58 AM
  #3  
Casper42's Avatar
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
Reply
Old Nov 5, 2004 | 01:32 AM
  #4  
ccannizz11's Avatar
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
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Yumcha
Automotive News
70
Dec 7, 2020 05:39 PM
Yumcha
Automotive News
4
Aug 15, 2019 12:58 PM
08_UA7_Gr33k
Member Cars for Sale
13
Feb 11, 2016 02:17 PM
InFaMouSLink
Car Parts for Sale
6
Oct 27, 2015 06:52 PM
08_UA7_Gr33k
Member Cars for Sale
1
Sep 27, 2015 01:56 PM




All times are GMT -5. The time now is 05:09 PM.