How to create a line chart for different selection dates?
Hi all,
I have a dashboard with different sheet tabs. The first tab is a selection tab where you can select the start date and end date, and also company's name. Based on the selections of dates and company name the next sheet tabs show different tables and charts.
Let me explain the situation with an example:
Window
Start Date
End Date
Company
M1
Jan 01, 2014
Jan 31, 2014
A
M2
Feb 01, 2014
Feb 28, 2014
B
M3
Mar 01, 2014
Mar 31, 2014
C
M4
April 01, 2014
April 30, 2014
D
On the first Selection tab, if I selected start date Jan 01, 2014 and end date Jan 31, 2014 for company A, then the chart displays a value for selected dates and company on the next sheet tabs. That is fine. But my question is can I able to show a line chart for window M1, M2, M3 and M4 all at once? If I can, what should I do? I was thinking to create alternate state for each windows frame selection, but it is going to be too many sheet tabs. Any ideas how to do it?