Excel: Add new series on a graph using a macro


Hello everyone. I am trying to create a macro. I am very inexperienced and my knowledge of coding is very minimal. I would be very grateful if anyone could help me out. Thank you :) This is a copy of my table (bold are the rows and coloums). The workbook is called "PSD Graphs". The Sheet is called "Cone Crusher PSD." I want to enter data on a weekly basis, adding more rows as the year progresses. I want to make a macro so I can select a date and add its row of data onto my graph.

B AE AF AG AH AO
5 90 50 31.5 25 0
236 3-jul 55.9 7.7 3.4 2.1 0
237 11-jul 40.2 8.3 1 1 0
238 24-jul 84.9 20.3 3.6 3.1 0
239 30-jul 36.8 13.9 0.8 0.6 0
I tried recording a macro and this is what I get: Sub Macro11() ' ' Macro11 Macro ' ' Keyboard Shortcut: Ctrl+m ' ActiveSheet.ChartObjects("Chart 5").Activate ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(2).Name = "='Cone Crusher PSD'!$B$238" ActiveChart.SeriesCollection(2).XValues = "={90,50,31.5,25}" ActiveChart.SeriesCollection(2).Values = "='Cone Crusher PSD'!$AE$238:$AO$238" End Sub When I select a date and try to apply my macro, it adds a blank series to my graph. Thank you again for any help!!


This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of August 08, 2014.


For more resources for Microsoft Excel