creating charts using macros which picks up source data from the active sheet??

Hi guys

Really stuck here - i'm very new to using macros. I have a lot of data needing to be processed. I have 5 sheets of data per excel file and need a way of running a macro to create charts in each sheet using the source data from that worksheet.

I can write the macro to create the chart but each time I run it on a new sheet it just uses the source data from the original sheet.

Please help?!

Ok, I found a way to use the active sheet for the source code using this:

Sub Tprofiles()
Dim NewChart As ChartObject
Dim SourceRng As Range

Set SourceRng = ActiveSheet.Range("A1:N800")
Set NewChart = ActiveSheet.ChartObjects.Add(1000, 100, 400, 200)

With NewChart.Chart
.ChartType = xlXYScatterSmoothNoMarkers
.SetSourceData SourceRng
End With

End Sub


Is there a way of automating the chart generation across the sheets without having to run the macro for each sheet individually?

Also - how do i put the chart and axis names into the macro?

Help appreciated!

Please Login or Register  to view this content.

That will let you name your chart and axes.

perhaps you could post an example for help with the rest