Macro for creating a chart
 

Hello, I had asked a question on the charts group a couple of days back. Was
wondering if anyone could help me with it here!

I have several sheets having similar data for different lanes. I have a macro
which can create a graph I want with different series plotted in different
forms for source data on a particular sheet. I want to be able to create a
graph for the active sheet.
How do I use ActiveSheet data as source data for the gaph.

Macro for creating a chart
 

Post your code, and someone will show you how to adapt it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Abhijeet wrote:

Hello, I had asked a question on the charts group a couple of days back. Was
wondering if anyone could help me with it here!

I have several sheets having similar data for different lanes. I have a macro
which can create a graph I want with different series plotted in different
forms for source data on a particular sheet. I want to be able to create a
graph for the active sheet.
How do I use ActiveSheet data as source data for the gaph.