#1
|
|||
|
|||
Update a summary chart when I update a dashboard with dates
I have a dashboard that I update on a daily basis. I have a summary chart that I send with the associated dashboard. How do I automatically update the summary chart with the new days' data?
|
#2
|
|||
|
|||
There's no way to answer without more detail. If you would attach the relevant sheets, it may be easier to get you an answer.
|
#3
|
|||
|
|||
As requested I have attached the file.
|
#4
|
|||
|
|||
OK. Let me see if I understand. On that first tab, you want the chart to show the data for, say, 9/24 when you enter it into the table above. Right off the top of my head, all you need to do is extend the range of each data series to the right in the Select Data dialog.
|
#5
|
|||
|
|||
Actually, what I want is for B5:B9 to update when I add a new column of data to the dashboard. So tomorrow, when I add in the data for 9/24, I want those numbers to automatically update in the fields I mentioned (B5:B9).
|
#6
|
|||
|
|||
Sorry. In your first post you said you wanted a chart updated.
If all you want to do is for B5-B9 to show the most recent data in the table, I'm sure that can be done a few ways. One way would be to do an hlookup. What hlookup does is looks for match in the top row of a specified table and then returns the value from a specified number of rows below. First, what is it looking up? The latest date, right? Enter =max(3:3) in the cell immediately above, B4. This will find the date with the greatest value in row 3. It's important that this equation is not in row 3 itself or you will get a circular reference. It doesn't have to be in row 4, but let's put it there for now. Rather than go into further detail, I've attached a copy of how this can be done. Let me know if I've missed your point or if you need anything more. |
#7
|
|||
|
|||
Thank you for your help. This is exactly what I was looking for. Very much appreciated.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update TOC | ubns | Word VBA | 22 | 08-14-2012 11:44 PM |
Hide Rows and Update Chart based on cell value | ubns | Excel Programming | 5 | 05-07-2012 05:44 AM |
Automatically update dates using a macro | matthew544 | Word VBA | 5 | 12-06-2011 03:19 AM |
live update | gilgold | Excel | 0 | 05-26-2010 10:49 AM |
VBA to update certain (but not all) fields | sparkyrose | Word VBA | 0 | 05-20-2010 12:50 PM |