Forum Discussion
Excel Charting Issue
I track weekly production numbers and am trying to create a chart that only displays up to the current week but updates as data is added. When selecting the source data range, I reference 52 cells f...
JW_in_MI Transform the data range to an Excel table and base your chart on the table. Add week at the bottom of the table and the chart will expand with every row you add.
See attached.