Forum Discussion
Dynamic range for chart
I have a two-level (two-column) range to populate horizontal axis in chart. Months in column A and 3 categories for each month in column B. I want to be able to make the two-level range a dynamic r...
I used a pivot table
it works fine
check the file
try adding a new month with data and check if the charts updates