I have a worksheet that contains a graph with daily sales data. I have a another worksheet that contains a summary of that data and comparison to goals.
What I would like to do is create a dashboard type text box that contains summary data (about a dozen rows, two columns). This box would hover above the worksheet containing daily data, remain anchored to the upper right, and dynamically update as values changed. Here's an oversimplified mockup.
One thing I forgot to add to the mockup: there are already 3 very dense lines of frozen headers, and while it's easy enough to add another line, I really want to get this to stand out for the user.
Excel pipe dream? Or does anyone have any ideas?