Home Forums Classifieds Blogs Today's Posts Search Social Groups



  
SIGN-UP
Notices

Glock Talk
Welcome To The Glock Talk Forums.

 
  
Reply
 
Thread Tools Display Modes
Old 06-10-2010, 03:06   #1
Originalsin
Senior Member
 
Originalsin's Avatar
 
Join Date: Dec 2000
Location: Australia.
Posts: 1,331
How do you make an Excel graph so the X-axis is to scale with the data?

Hi all,

I'm trying to plot some data I have on Excel 2003. The data is from a 14-day set of observations. Not every day has data, and some of the data is from between days, eg. day 13.5. For example, I have data for days 0.5, 1, 4, 7, 11, 12 etc, but not for days 2 or 3. I have no problem making a graph, but the problem is that I cannot make it to scale. For example, I would like days 0.5 and 1 to appear 0.5 arbitrary units apart on the X-axis, and days 1 and 4 to be 3 units apart, to give a visually accurate representation of how the data is changing over time. Plotting them all 1 unit apart regardless of days between does not look good, and does not really represent the data well.

Can anyone help?

Cheers,

Originalsin
__________________
Lo there do I see my father. Lo there do I see my mother and my sisters and my brothers. Lo there do I see the line of my people back to the beginning. Lo they do call to me, they bid me take my place among them. In the halls of Valhalla. Where the brave may live forever.
Originalsin is offline   Reply With Quote
Old 06-10-2010, 03:53   #2
Originalsin
Senior Member
 
Originalsin's Avatar
 
Join Date: Dec 2000
Location: Australia.
Posts: 1,331
Right. Found a way. Had to do it as a scatterplot. That seems to work.

Next thing to figure out is how can I make it so that the data starts at day 7, with day 14 in the middle, and continues to day 7 again... mutter mutter mutter...

Even if I can modify the labels on the X-axis afterwards, that would work, if there's a way...
__________________
Lo there do I see my father. Lo there do I see my mother and my sisters and my brothers. Lo there do I see the line of my people back to the beginning. Lo they do call to me, they bid me take my place among them. In the halls of Valhalla. Where the brave may live forever.
Originalsin is offline   Reply With Quote
Old 06-10-2010, 04:09   #3
Originalsin
Senior Member
 
Originalsin's Avatar
 
Join Date: Dec 2000
Location: Australia.
Posts: 1,331
Sorted.
__________________
Lo there do I see my father. Lo there do I see my mother and my sisters and my brothers. Lo there do I see the line of my people back to the beginning. Lo they do call to me, they bid me take my place among them. In the halls of Valhalla. Where the brave may live forever.

Last edited by Originalsin; 06-10-2010 at 05:21..
Originalsin is offline   Reply With Quote

 
  
Reply

Thread Tools
Display Modes

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




All times are GMT -6. The time now is 13:38.




Homepage
FAQ
Forums
Calendar
Advertise
Gallery
GT Wiki
GT Blogs
Social Groups
Classifieds


Users Currently Online: 1,219
298 Members
921 Guests

Most users ever online: 2,672
Aug 11, 2014 at 2:31