I have a list of data that is updated every day and exported from another program into an excel file. This data is in long columns of some 2500+ rows. The column headings are date, type, status, field name. Every block of 50 rows is various data for the same field name. I would like to automate chart making for each block of 50 rows. The chart will be exactly the same format with exactly the same amount of data. Here is what the macro creates for one chart:
Expand|Select|Wrap|Line Numbers
- Sub Macro12()
- ActiveSheet.Shapes.AddChart.Select
- ActiveChart.ChartType = xlLine
- ActiveChart.SeriesCollection.NewSeries
- ActiveChart.SeriesCollection(1).Values = "='Sheet1'!$D$2:$D$50"
- ActiveChart.SeriesCollection(1).XValues = "='Sheet1'!$F$2:$F$50"
- End Sub