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