View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wadep wadep is offline
external usenet poster
 
Posts: 1
Default User directed graphing?

Hello, I another excel newbie, i made an excel file that produces a set of
data. which is basicaly company A, company B, etc... againste months of hte
year etc.. the info is basicaly cost etc.. i want to be able for the user to
quicly look at the data and select the 3 cheapest companies and produce a
graph from the 10 or more companies etc. like a check box or something like.
the data changes everytime you need the excel sheet so knowning the cheapest
company isn't known until the calculations is done. how would i go about
doing this? would i approach this with VB or is there some wizard/tool built
in excel 2003 that would help?