Sep 10 2018 04:54 PM
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
Sep 10 2018 11:20 PM
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?