Hi, I need some information on charting in excel.
I have a spredsheet with 164 total rows of data. From that data, I have to sort the data and create charts off of that data. For example:
Category occurances
Dogs 2
cats 4
mice 6
rats 7
elephants 1
One of my charts I have to have the top 3 categories charted by the greatest number of occurances. Is there any way to pull that data without having to sort the occurances by either decending or accending or by creating a count forumal and taking the data from there to make the charts? In other words, is there a way to update the charts, without having to sort the data?
The reason I ask is because i have 3 seperate charts to sort and everyone knows when sorting, data can be mixed up if not done correctly.
Thanks in advance for all of your help!
Bookmarks