Automated task to present data in a graph form.

[luckyguy]

Hi,

I am newbie to Excel area. I got a requirement where in I need to
present the Excel sheet data with 3 columns in a graphical form.
Everyday, the excel sheet is populated with the current data. This is
automated from the backend.

I want to know whether there is any possibility of a macro which draws
a graph with the data present in the excel sheet. It should be an
automated task.

Thanks for the help in advance.

 

[Tushar Mehta]

In addition to Jon's suggestion, you may also want to look at
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