Thread: Query
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Frikkels Frikkels is offline
external usenet poster
 
Posts: 4
Default Query

I have a spreadsheet with one column that contains random numbers - I need to
group these numbers in fields - "0-5" "6-10" & " over 10" I want to create a
Pie Chart with those three groupings, what is the best way to do this,thatt
if a number changes that it will change the quantity in one of those 3
groupings. I want it to calc automatically...any ideas, and if so please can
I have an example as well....

Many Thanks