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.

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.
>