Steve - thanks for the "demo" data structure. It helped me help you.
Here's your solution (see tip here: http://www.techrepublic.com/blog/msoffice/how-to-find-blank-records-using-excels-advanced-filter/3644)
Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data.
Rather than update each graph to point to a different set within a static set of data, t…