I'm working on a simple dashboard that will contain highlights of information for baseball teams. I've successfully figured out how to change the picture dynamically through named ranges and Picture Links.
Now what I'd like to do is include a line chart on the dashboard page showing the total data points (could be anything- sales, attendance, revenues, popularity rating) for each month. The trick is not all of the teams will have information for every month and/or may not stop in Jan. and end in Dec.
I'm wondering if there is a way to dynamically create the chart so that it picks the correct range on the x and y axes and shows the data points for those month/data point intersections.
Any body know how to do that if it's possible?