Self updating excel graphs best compare dating site uk
We’ll name the cell in the first row of each metric column as the current value for that metric (the cells don’t to be named cells, but it makes for easier, safer updating of the dashboard as the complexity grows).Name each cell by clicking on the cell, then clicking in the cell address at the top left and typing in the cell name.
We want to look at the currently selected Report Period (a named range called Report Period) and find the value for each metric that is in the same row as that report period.
That will give us the “Current” value for each metric.
So, we need to make it a named cell — Report Period: Now, let’s do a similar operation for the report range — this tells the spreadsheet how many months to include in each chart.
Click in cell C3, select Data » Data Validation, choose List, and then enter the different values you want as options (I’ve used 3, 6, 9, and 12 here, but any list of integers will work): And, let’s name cell Report Range: Does this seem like a lot of work?
If you are looking for other Excel 2010-specific information that this post doesn’t cover, please leave a quick comment as to what the change/issue is that led you to the search.