Drawing graphs using VBA

[sravyen]

Hello everyone,

I am new to VBA and I don't know how to draw graphs using macros.I
have a Excel sheet with all the calculations(Uses an equation) and I
want to get a graph after I give some input values needed to get the
graph.I want mt Excel sheet to look good without any calculation to be
seen to the end-user.I want the end user to give few input values and
a graph needs to pop up using the calculations.
Can anyone help me out how I can do this using VBA?

Sravanthi.

 

[Jeff Hopper]

Sravanthi - Try using the Excel Chart object. Here are a couple of
samples--I'm sure there are more out there if these don't fit your needs...

http://msdn2.microsoft.com/en-us/library/bb404904.aspx
http://msdn2.microsoft.com/en-us/library/aa168463(office.11).aspx

Jeff