View Single Post
  #1  
Old March 7th, 2006, 12:56 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default quickly select data to produce charts

Hi

We need to produce charts comparing different variables. The data layout is
simple:
Item 1 Item2 Item 3 - & so on
2.3 1.2 3.5
1.1 2.3 4.2
There is up to 12 columns and 20 rows.
All need to be compared against each other.
Is there a way to choose two variables and then have these updat einto a
chart?
i.e 1 compared with 2, 1 compared with 3 then 4 and so on
I found examples with drop down boxes for one varaible but not two
Help appreciated