Forum Discussion
Formula that can update automatically each month to show monthly KPI
I downloaded a template with a dashboard that shows monthly metrics taken from other worksheet pages, to give an at-a-glance view of important KPI's. I don't want to use the rest of the template, so ...
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.