Site Statistics
 
Threads: 4,037
Posts: 17,684
Members: 3,035
Users Online: 14
Newest Member: cerilah


Go Back   PC101 > Computer Related Forums > Software
Reload this Page Need some Excel help...

Software Ready to buy some new software or have questions and have a question? Looking for suggestions? Having problems with a particular application? This is the place to post your questions and opinions concerning all non-operating system type software.


Reply
 
LinkBack Thread Tools Display Modes
Old 07-09-2007, 12:37 AM   #1
Head Mistress
 
Lyte's Avatar
 
Join Date: Oct 2005
Location: Good ol' U.S. of A
Posts: 3,448
Rep Power: 6 Lyte is on a distinguished road
Send a message via MSN to Lyte Send a message via Yahoo to Lyte Send a message via Skype™ to Lyte
Need some Excel help...
Howdy!

I need some help with creating a graph on Excel. I'm looking for a line graph that demo four pieces of information. For example... the X access (is that the horizontal one at the bottom?) would be time in 30 minute intervals. The Y axis would be... whatever... lets say dollars... between 1 and 10. The dollars could be expressed in "fractions of" as in $1.50 or $.95. And... the third and fourth bits of information could me widgets built (A) and widgets makes on duty (B).

What I'm wanting to see what correlation there might be between A & B and Y over time (X). So, I want to be able to plug in numbers for X, A & B and see how they relate to one another.

So... anyone a graph wiz and willing to make something like that me?

Thanks!
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Lyte is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 07-09-2007, 07:20 AM   #2
Sophomore
 
Join Date: Feb 2007
Posts: 30
Rep Power: 0 Vyoma is on a distinguished road
I am not very sure on what you are asking - but a four column data table with the first one being the time and the remaining 3 being X, A and B - and insert a chart with that area selected - that will give you a graph as you wanted.

I am not sure what you mean by plug in.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
at
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Vyoma is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 07-09-2007, 09:32 AM   #3
Head Mistress
 
Lyte's Avatar
 
Join Date: Oct 2005
Location: Good ol' U.S. of A
Posts: 3,448
Rep Power: 6 Lyte is on a distinguished road
Send a message via MSN to Lyte Send a message via Yahoo to Lyte Send a message via Skype™ to Lyte
Oh...sorry... "plug in" for me means enter data and have it populate on the graph.

I've been going 'round and 'round with my Excel here at home and can't figure out how to create the graph so it works as I discribed. Plus, I'd prefer a line graph vs. a column graph.

Lyte
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Lyte is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 07-09-2007, 09:57 AM   #4
Sophomore
 
Join Date: Feb 2007
Posts: 30
Rep Power: 0 Vyoma is on a distinguished road
If I am getting it right, you should be able to do it.

Let me whip up something and get back.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
at
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Vyoma is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 07-09-2007, 10:02 AM   #5
Head Mistress
 
Lyte's Avatar
 
Join Date: Oct 2005
Location: Good ol' U.S. of A
Posts: 3,448
Rep Power: 6 Lyte is on a distinguished road
Send a message via MSN to Lyte Send a message via Yahoo to Lyte Send a message via Skype™ to Lyte
Kewl! One of the guys at work showed me how... but it was kind of in passing and I didn't quite catch everything.

Thanks!

Lyte
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Lyte is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 07-09-2007, 10:27 AM   #6
Sophomore
 
Join Date: Feb 2007
Posts: 30
Rep Power: 0 Vyoma is on a distinguished road
Ok. Here is a graph that I made with random data:



PM me your email address - I will mail you the excel document - you can check it up.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
at
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Vyoma is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 07-10-2007, 11:48 AM   #7
Head Mistress
 
Lyte's Avatar
 
Join Date: Oct 2005
Location: Good ol' U.S. of A
Posts: 3,448
Rep Power: 6 Lyte is on a distinguished road
Send a message via MSN to Lyte Send a message via Yahoo to Lyte Send a message via Skype™ to Lyte
Coolio! You can send it to PC101's email at info(at)pc101(dot)com

Many thanks!

Lyte
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Lyte is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 07-10-2007, 01:52 PM   #8
Sophomore
 
Join Date: Feb 2007
Posts: 30
Rep Power: 0 Vyoma is on a distinguished road
Sent!
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
at
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Vyoma is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Perl Compiler | Dreamweaver 8 Keyboard Shortcuts—PC »
Thread Tools
Display Modes
Linear Mode Linear Mode

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
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 04:57 AM.

Powered by vBulletin Version 3.7.0
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0 RC5


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30