Register Login
endrop - for all your online needs
Reply
 
Thread Tools
Old 14-04-2011   #1
Join Date: May 2007
Location: Cardiff
Posts: 497
Thanks: 7
Trader Rating: 0
United Kingdom 
Excel graphs problems -SOLVED IGNORE

Hello


I am trying to make some line graphs in excel for my dissertation, but im having a problem which is quite hard to explain. Now both axis are numberd. On the vertical axis, i have a nice even scale going for the range of numbers i have input, but on the horizontal, the points are evenly spaced. for example say i put 3, 4 and 8 in for the horizontal, they arent evenly distributed along a numeric scale, but have equal spacing between them.

How can I alter this so the horizontal scale is like the vertical scale?

Here is a link to an image of the problem

http://img847.imageshack.us/i/grapho.jpg/

Thank you

EDIT - found that changing it to a scatter graph rather than a line graph solved this
__________________
Panda 1.2 Dynamic 57

Last edited by garlicbread22; 14-04-2011 at 15:38.
garlicbread22 is offline Reply With Quote Quote 
Old 14-04-2011   #2
42 Wallaby Way Sydney
 
bludvl_x19's Avatar
Join Date: Mar 2007
Posts: 3,292
Thanks: 65
Trader Rating: 0
bludvl_x19 has donated!
Australia 
Re: Excel graphs problems -SOLVED IGNORE

Its a pleasure to have been able to help
__________________


Try not to become a man of success but rather try to become a man of value. ~Albert Einstein
bludvl_x19 is offline Reply With Quote Quote 
Old 14-04-2011   #3
Join Date: Sep 2009
Posts: 14,550
Thanks: 706
Trader Rating: 0
United Kingdom 
Re: Excel graphs problems -SOLVED IGNORE

Otherwise (IIRC) double click on the graph axes to edit. Just be glad you are not forced to use SPSS/PASW
__________________
FIAT Forum Useful Links:
Donate to FF | Buy FF Merchandise | Classifieds | FF Insurance | How-to Guides

DaveMcT is offline Reply With Quote Quote 
Reply
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump
Similar Threads
Thread Thread Starter Forum Replies Last Post
(T) power and torque graphs for 1.2 and 1.4 engines suah 500 16 26-06-2009 15:27
(T) Bravo Multijet 150 Sport - Remap + Graphs Dave_R Bravo 33 14-07-2008 00:24
Pop Graphs soopahfly Leisure Lounge 0 05-03-2008 11:59
Help!!! Excel coolme2k Leisure Lounge 5 28-03-2006 00:30
help with excel philbo Leisure Lounge 2 03-03-2006 19:09