Chart Dynamic Range

[Montyzzz]

Hello,

Using Excel 2016. I created a chart with a chart data range from B2:F13. I created a macro that will insert a column in C:C. This causes my chart data range to now =B2:B13,D2:F13. The new data in column C is not being displayed on the chart. I have a screenshot, but I'm unsure how to display it on this message board.

Is there a setting to prevent this from happening? Is there an efficient solution out there somewhere? Thank you.

 

[JLGWhiz]

I created a chart and then named the range for the source data, including headers for both axes. I then inserted a column and added data to the column, The chart plotted the data and automatically expanded thed horizontal source range to accomodate the inserted column.