+ Post New Thread
Results 1 to 3 of 3
Office Software Thread, Automatic Graph in Excel in Technical; Quick question for any Excel geniuses out there. I have a sheet in Excel which contains pupils' names and their ...
  1. #1

    Join Date
    Jul 2007
    Posts
    42
    Thank Post
    3
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Automatic Graph in Excel

    Quick question for any Excel geniuses out there. I have a sheet in Excel which contains pupils' names and their spelling ages throughout their school career.

    At the moment, i've got all the information feeding into a bar chart but it displays every child's data on one big chart. Is there a way of adding something like a dropdown list to the chart so that a user can pick which child's data they want to chart?

    Thanks for any help

  2. #2

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180
    In Office 2010 you can add 'sparklines' or bar charts within a cell next to each dataset... not sure how useful this would be to solving your problem though.

  3. #3

    Join Date
    Jul 2007
    Posts
    42
    Thank Post
    3
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Thanks for that Ric - the sparklines look great but it would involve us buying third party software to achieve that in Office 2007. Looks interesting though

    Any other ideas?
    Last edited by cgiuk; 20th May 2010 at 03:40 PM.

SHARE:
+ Post New Thread

Similar Threads

  1. [CLOSED] Missing Content: PM usage graph
    By FN-GM in forum EduGeek.net Site Problems
    Replies: 2
    Last Post: 9th April 2010, 09:33 AM
  2. graph showing users/time for edugeek
    By mjs_mjs in forum Comments and Suggestions
    Replies: 0
    Last Post: 15th March 2010, 08:47 AM
  3. graph data on apache
    By CyberNerd in forum *nix
    Replies: 5
    Last Post: 5th November 2008, 01:25 PM
  4. [MS Office - 2007] Graph labels
    By imiddleton25 in forum Office Software
    Replies: 1
    Last Post: 10th September 2008, 03:25 PM
  5. Bulk edit graph tree - Cacti
    By Joedetic in forum Wireless Networks
    Replies: 2
    Last Post: 10th June 2008, 06:14 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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