updating data range for column charts in VBA

[st0pped]

hi,

i'd like to ask about my macros regarding updating the data range for my column charts after inserting a new row with a few column values.

i tried to record a macro by selecting the existing column chart i had and changing its data range to the new data range (shift+ctrl+down). however, each time i add in a new row, the data range for the column chart is not updated automatically when i click the button with the assigned macro.

is there any way i can go about doing this?

thanks!

[Andy Pope]

Why not post the code you have and the workbook explain exactly what you do to add data and then run your code.

[st0pped]

Sub updateandview4weekgraph1()
'
' updateandview4weekgraph1 Macro
'

'
Sheets("4-week graph").Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).Name = "=""No. of Failure"""
ActiveWindow.SmallScroll Down:=-141
End Sub

this is what i have but i recorded macro and i didn't type the code in.
1) so basically i would click on the '1st macro' which updates the data range i have by one additional row at the bottom.
2) therefore, i created this macro, which i start from another sheet and then go to '4-week graph' tab where the graph is. i already have a graph with the old data, and i'll right click-> 'select data' and then i'll shift+control+right+down to select the entire new data range with one updated row.
3)i'll then stop my recording after that.

is this okay? sorry im not very sure if this description helps coz it's the 1st time i'm posting sth here. thanks anyway!

[Andy Pope]

Please add code tags to your post.

Can you post example workbook?