interactive graphs in excel

[Guest]

I did come across an article for changing data interactively. Can some one
point me to that.
Thanks
MVM

 

[Debra Dalgleish]

Jon Peltier has instructions for interactive charts:

http://www.peltiertech.com/Excel/Charts/Dynamics.html#SheetControls

If that's not what you're looking for, someone may be able to help if
you provide a few more details as to what article you saw.

 

[Guest]

MVM,

In addition to Jon's site that Deborah mentioned, here's an article that
might help. It also has a link to some of Jon's TechTrax article on charting
dynamic dates.

http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=518

 

[Tushar Mehta]

Depending on what you mean, check the various examples in Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

 

[Guest]

Thank you all. It is of great help.
MVM

 

[Guest]

In the form control I am trying assign the input range to a row of cells. It
is not working. dropdown list is filled only with the first cell content.

my idea is to put one dropdown for each column in sheet2
sheet1 contains some products with information - one column for each product.
I want the product names to be filled from top row of sheet1.
by choosing one product from the list, that column data is copied from
sheet2 column for that product.

Thank you
MVM