Forum Discussion
Formula that can update automatically each month to show monthly KPI
This is pretty simple. This graphics are called tiles or cards and can be reproduced using a chart or sparkline and some cell formatting or the incorporation of textboxes with formulas. Do you have an example file with non-sensitive raw data that we could look at for reference? Or perhaps the original file you received? The more detail you can provide on your data structure and it's anomalies the better solution the community will be able to provide.
Before and After Examples are especially helpful.
Hi Matt,
Thank you for your help. I'm attaching the document I'm creating based on the template. I figured out how to add text to formulas and got the %monthly change section working in the "email open rate" box on the summary tab. What I'm really stuck on is the numbers in large font in the template. Somehow the template updates those numbers whenever a new month's data is entered on the other worksheets. I can't figure out how to get Excel to find the new month's data to update automatically. If I link the summary tab cell to a single month's cell in another worksheet, I'll have to redo the formula each month, which would defeat the purpose of the quick dashboard view.