Forum Discussion
Adding variable in chart series formula
Hi, I've created a spreadsheet which tracks monthly sales of each of the 40 products I sell, and have created line charts for each product showing sales by month. Each month I add a column to the r...
huw_jones One option is to set up a chart that has a dynamic range that you can control by specifying which data is included in the chart. I wrote an article with detailed instructions for this at https://www.thinkoutsidetheslide.com/how-to-create-an-excel-chart-with-a-dynamic-range-that-you-select/.
Hope that helps.