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 ...
19th May 2010, 09:39 AM #1
- Rep Power
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
19th May 2010, 09:53 AM #2
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.
19th May 2010, 09:58 AM #3
- Rep Power
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 04:40 PM.
By FN-GM in forum EduGeek.net Site Problems
Last Post: 9th April 2010, 10:33 AM
By mjs_mjs in forum Comments and Suggestions
Last Post: 15th March 2010, 09:47 AM
By CyberNerd in forum *nix
Last Post: 5th November 2008, 02:25 PM
By imiddleton25 in forum Office Software
Last Post: 10th September 2008, 04:25 PM
By Joedetic in forum Wireless Networks
Last Post: 10th June 2008, 07:14 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)