Forum Discussion
Excel Chart auto add another line of data to a chart
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 ...
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?