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!