Automated task to present data in a graph form.
 

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.


--
luckyguy
------------------------------------------------------------------------
luckyguy's Profile: http://www.excelforum.com/member.php...o&userid=28503
View this thread: http://www.excelforum.com/showthread...hreadid=481002

Automated task to present data in a graph form.
 

In addition to Jon's suggestion, you may also want to look at
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/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

In article ,
says...

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.


--
luckyguy
------------------------------------------------------------------------
luckyguy's Profile: http://www.excelforum.com/member.php...o&userid=28503
View this thread: http://www.excelforum.com/showthread...hreadid=481002