Macro for creating a chart

A

Abhijeet

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

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a dynamic master file 1
Consolidation Table from Different Excel Tabs with Different Format 1
Help: Chart & data 1
Creating a Chart on form from selected data in query. 0
Macros to convert Data into date format and then plot in graph 7
VBA Coding Help for Beginner 0
Drop down list control value in vba 2
Chart using Macro 0

Top