Excel Chart auto add another line of data to a chart

Copper Contributor

Column A has the weeks going down, columns going across has the values

Bar Chart, want it to automatically add another 1eries for the weeks as data is added to the chart.

Should I do this manually via a macro

Or can I do a formula to add the horizontal category

Don't want to have to update the chart manually every time a week is added.

 

Dates -         This is B   This is C  This is D    This is E

30 Aug 18      15              5                    3           2

06 Sep 18      12              3                    3           1

 

Want the chart to add the 06 Sept 18 series and its values.

 

Thanks

1 Reply

Hello,

 

so, each week is a new series? In that case, you will need VBA to add new series to the chart. 

 

If you only add data points to existing series, this can be done without VBA, just with dynamic range names. 

 

Can you post a file with a little data sample and chart?