1. We have added a Gift Upgrades feature that allows you to gift an account upgrade to another member, just in time for the holiday season. You can see the gift option when going to the Account Upgrades screen, or on any user profile screen.
    Dismiss Notice

Your chance to Excel?

Discussion in 'Computer Talk' started by bathsheba666, Mar 8, 2009.

  1. bathsheba666

    bathsheba666 Fast 'n Bulbous

    Joined:
    Feb 19, 2005
    Messages:
    10,012
    Location:
    London
    Hi everyone,

    I have a teenager with an attitude and some homework...
    Any excel wizards to the rescue?

    Given the following data

    Day 1: 2 inches; SW
    Day 2: 3 inches; NW
    Day 3: 4 inches; SW
    Day 4: 0 inches; NE
    Day 5: 1 inch S

    I would like a bar chart showing rainfall by day, namely 2,3,4,0,1

    Each bar should be coloured according to wind direction;
    so different colours for each direction,
    identical colours on above data for day 1 & 3.

    Thanks muchly...

    (obviously, the real data is much more extensive and varied than the above, but the principle holds)
     
  2. heliogabalus

    heliogabalus Warlord

    Joined:
    Jul 10, 2002
    Messages:
    297
    Location:
    Germany
    Thanks for the offer, but I'm forced to take my opportunity to Word now.
     
  3. Mise

    Mise isle of lucy

    Joined:
    Apr 13, 2004
    Messages:
    28,601
    Location:
    London, UK
    You need to set up 8 different series for the directions. So, have 8 different columns, one for each direction. Then, put the speed in the appropriate column, e.g.:

    .....N....NE....E....SE....S....SW....W....NW
    1...0.....0.....0......0.....0....2......0......0..
    2...0.....0.....0......0.....0....0......0......3..
    3... etc

    Then just use the bar chart wizard thingo for each series. Each series (bar) will have a different colour. You can tweak the "Overlap" and "Gap" in the bars to make them look better.
     
  4. nonconformist

    nonconformist Miserable

    Joined:
    Jun 11, 2003
    Messages:
    18,740
    Location:
    Canterbury
    Slap 'im .
     
  5. bathsheba666

    bathsheba666 Fast 'n Bulbous

    Joined:
    Feb 19, 2005
    Messages:
    10,012
    Location:
    London
    He's 13, and bigger than I am......


    @Mise:
    thanks, I will investigate...
     
  6. bathsheba666

    bathsheba666 Fast 'n Bulbous

    Joined:
    Feb 19, 2005
    Messages:
    10,012
    Location:
    London
    I don't consider that a power point.
     
  7. Cheezy the Wiz

    Cheezy the Wiz Socialist In A Hurry

    Joined:
    Jul 18, 2005
    Messages:
    25,238
    Location:
    Freedonia
    You must get a better outlook on life.
     
  8. bathsheba666

    bathsheba666 Fast 'n Bulbous

    Joined:
    Feb 19, 2005
    Messages:
    10,012
    Location:
    London
    Ah, then I could C#
     
  9. Mirc

    Mirc Not mIRC!!!

    Joined:
    Jun 27, 2005
    Messages:
    15,825
    Location:
    Düsseldorf, ->Germany, E.U.
    Nah, what you really need is better access to online resources, you need a path to find the published info.
     
  10. Gogf

    Gogf Indescribable

    Joined:
    Oct 12, 2003
    Messages:
    10,163
    Location:
    Plane Of Fish Sticks
    If one thinks back to the original point in the OP, one notes that all he has to do is input the data, select it, find the "chart" or "graph" button or whatever, and then mess around with the settings until it looks right. That's what I do whenever I need a graph.
     
  11. bathsheba666

    bathsheba666 Fast 'n Bulbous

    Joined:
    Feb 19, 2005
    Messages:
    10,012
    Location:
    London
    Thanks, Mise.
    Your suggestion did the trick.



    @Gogf, thanks for participating.
     
  12. Knight-Dragon

    Knight-Dragon Unhidden Dragon Retired Moderator

    Joined:
    Jun 25, 2001
    Messages:
    19,963
    Location:
    Singapore
    Moderator Action: Moved to CompTalk.
     

Share This Page