Page 1 of 2 12 LastLast
Results 1 to 15 of 16

Thread: Excel Graphs

  1. #1
    Cricket Web Content Updater alternative's Avatar
    Join Date
    Jan 2006
    Location
    Sydney, Australia
    Posts
    11,114

    Excel Graphs

    I needed some extensive help in graphing, so i thought i would ask our friendly CW members to help me do some simple graphs(that's what i think) on excel.

    I am here with attaching the excel file with all the data. What i need is a linear graph with Urea Vs Influx. The results are so crap that i know i wont get a linear graph but is there any chance i can get a trendline on it though.

    Any sort of help would be appreciated

    Exp 1 report.xls
    Member of the AAAS
    Member of CW Green | Stedingham Jets Grade Cricket Team | Northside Power

    Manager of South Australia (WCC)

    Winner of AFL Tipping 2006 | Winner of Wimbeldon Prediction 2006

  2. #2
    Banned
    Join Date
    May 2006
    Location
    Sydney
    Posts
    3,746
    Wow very quick!

  3. #3
    Cricket Web Content Updater alternative's Avatar
    Join Date
    Jan 2006
    Location
    Sydney, Australia
    Posts
    11,114
    Quote Originally Posted by AussieDominance View Post
    Wow very quick!
    WTF????

  4. #4
    Cricket Web: All-Time Legend Matteh's Avatar
    Boredmeeting Champion!
    Join Date
    Jul 2005
    Location
    Midlands
    Posts
    22,939
    It hasn't been a good night for young Rodgie.
    Quote Originally Posted by cpr View Post
    3. Although Cow Tipping is a hilarious student game in backwater towns such as Bangor, there really is no need for Mitchell to cover one side of the cow in superglue


  5. #5
    Cricket Web: All-Time Legend Perm's Avatar
    Join Date
    Feb 2006
    Location
    Clutha Valley, New Zealand
    Posts
    21,816
    Don't have excel on this computer at the moment, but I am just about to put it on and then I should be able to help you. We've been doing trendlines in Stats for the last week or so.
    The Future of International Cricket - Rohit Sharma, Suresh Raina, Ravi Bopara, Tim Southee, Ross Taylor, Shahriar Nafees, Raqibul Hasan, Salman Butt, JP Duminy
    Proud Supporter of the Bangladeshi Tigers
    Ryan ten Doeschate - A Legend in the Making
    MSN: zacattack90@hotmail.com

    Quote Originally Posted by Richard View Post
    Romance can be dealt with elsewhere - I just don't enjoy it in cricket.

  6. #6
    Cricket Web Content Updater alternative's Avatar
    Join Date
    Jan 2006
    Location
    Sydney, Australia
    Posts
    11,114
    Champion

  7. #7
    Cricket Web: All-Time Legend Perm's Avatar
    Join Date
    Feb 2006
    Location
    Clutha Valley, New Zealand
    Posts
    21,816
    Actually no, installion failed. But once you graphed the data, you go to "Chart" and then "Add Trendline". Make sure you select linear and then it should work for you.

  8. #8
    Cricket Web: All-Time Legend Samuel_Vimes's Avatar
    Defend Your Castle Champion! Monkey Diving Champion!
    Join Date
    Aug 2003
    Location
    Bonn, BRD
    Posts
    22,964
    Last edited by Samuel_Vimes; 06-04-2007 at 05:17 AM.
    Messi scores on the rebound.

    Founder of ESAS - Edgar Schiferli, the best associate bowler
    A follower of the schools of Machiavelli, Bentham, Locke, Hobbes, Sutcliffe, Bradman, Lindwall, Miller, Hassett and Benaud
    Member of JMAS, DMAS, FRAS and RTDAS

    Quote Originally Posted by Adolf Grünbaum
    Is the conduct approved by the gods right ("pious"), because of properties of its own, or merely because it pleases the gods to value or command it?

  9. #9
    Cricket Web Content Updater alternative's Avatar
    Join Date
    Jan 2006
    Location
    Sydney, Australia
    Posts
    11,114
    Quote Originally Posted by Samuel_Vimes View Post
    Link doesn't work

  10. #10
    Cricket Web: All-Time Legend Samuel_Vimes's Avatar
    Defend Your Castle Champion! Monkey Diving Champion!
    Join Date
    Aug 2003
    Location
    Bonn, BRD
    Posts
    22,964
    Quote Originally Posted by alternative View Post
    Link doesn't work
    Try again.

  11. #11
    International Vice-Captain open365's Avatar
    Join Date
    Sep 2004
    Location
    liverpool
    Posts
    4,066
    Btw, if you just can't work excell for your graphing needs, check out a program called origin, i used it for my maths coursework.

  12. #12
    Cricket Web Content Updater alternative's Avatar
    Join Date
    Jan 2006
    Location
    Sydney, Australia
    Posts
    11,114
    Quote Originally Posted by Samuel_Vimes View Post
    Try again.
    WOW. Exactly what i wanted
    Thank you

  13. #13
    Cricket Web Content Updater alternative's Avatar
    Join Date
    Jan 2006
    Location
    Sydney, Australia
    Posts
    11,114
    Quote Originally Posted by open365 View Post
    Btw, if you just can't work excell for your graphing needs, check out a program called origin, i used it for my maths coursework.
    Cheers mate

  14. #14
    Hall of Fame Member Jamee999's Avatar
    Join Date
    Oct 2003
    Location
    Leicestershire, UK
    Posts
    15,094
    Quote Originally Posted by Matteh View Post
    It hasn't been a good night for young Rodgie.
    It's not been a great life for him.
    Or something.

    RIP Fardin Qayyumi (AKA "cricket player"; "Bob"), 1/11/1990 - 15/4/2006

  15. #15
    Cricket Web Owner James's Avatar
    Join Date
    Oct 2001
    Location
    Sydney, Australia
    Posts
    23,956
    Quote Originally Posted by Jamee999 View Post
    It's not been a great life for him.
    Regardless of how you meant this, don't make comments like this. Regardless of what you think of Rodgie, remarks like this do no good at all.

Page 1 of 2 12 LastLast


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating a cricket game in VBA (MS Excel)
    By LankanPrince in forum General
    Replies: 1
    Last Post: 21-03-2010, 05:16 PM
  2. Why i cannot upload Excel files
    By biased indian in forum Site Discussion
    Replies: 18
    Last Post: 08-08-2006, 01:33 PM
  3. Replies: 468
    Last Post: 09-11-2005, 10:38 PM
  4. Excel Cricket
    By Lach in forum General
    Replies: 0
    Last Post: 11-12-2001, 03:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •