Designing a Chart that expands as more data is entered in Excel
- by Matt Ridge
I have a worksheet that pulls data from another, it is designed to only show late jobs, and it works perfectly. I have it where it is broken down into quarters, and it gathers all this data and does everything I want. Except this one last bit...
I want to have it where it shows charts, if there is data in said area the chart would self populate,…