Hi all, I've got some sales data for the last couple of years and i can chart it cumulatively, all branches or the first one in my list, however i really don't know how to go about altering it to pick up the next rows, but not the first - if that makes sense? It will generate a large number of graphs - 250+ but that is what has been requested.
I'm very new to VBA and I have used the very basic
Code
Sub Macro1()'
' Macro1 Macro
'
'
Range("A1:F242").Select
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlLine
ActiveChart.SetSourceData Source:=Range("'Working Data'!$A$1:$F$242")
End Sub
Display More
to compile both my first branch chart for the last 5 years and my cumulative. I've added a test file to see if anyone is in a position to assit with how i would generate the separate graphs
Many Thanks in Advance