+ Reply to Thread
Results 1 to 1 of 1

New here and need help!

  1. #1
    Registered User
    Join Date
    01-11-2005
    Posts
    2

    Automaticly updating charts when editing data

    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!
    Last edited by AndiGirl; 01-11-2005 at 11:39 AM. Reason: Changed title

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1