• Hot Topics

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. 5 236 237 238 239 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

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

This thread is current as of August 8, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel

privacy policy