I've multiple indicators (61 in rows) and 40 areas (in columns) from where the data is collected on a monthly basis.
I'm thinking of creating a dynamic chart (or some other thing) which can get the data from 6 sheets (Jan-June) with 2 criterion (1 from row and 1 from column).
So, the chart will be something like...
1 criteria selected from indicator (row) and the graph will show the data of a particular selected area (from column, for all 6 sheets).
I don't know if its possible or not in excel. Have tried googling for dynamic charts but its not what i'm looking for. Please Help
I'm thinking of creating a dynamic chart (or some other thing) which can get the data from 6 sheets (Jan-June) with 2 criterion (1 from row and 1 from column).
So, the chart will be something like...
1 criteria selected from indicator (row) and the graph will show the data of a particular selected area (from column, for all 6 sheets).
I don't know if its possible or not in excel. Have tried googling for dynamic charts but its not what i'm looking for. Please Help