mrxlsx
Board Regular
- Joined
- Dec 15, 2012
- Messages
- 95
Hi all,
I have difficulty in building OFFSET formula to access my chart data dynamically. My data layout is as below.
<tbody>
</tbody>
If I select any State in the cell A8, I should get the chart highlighting with all the Qty, Sales, Cost, Profit etc with the State name as the chart title. If I change the State in the drop down, data should change accordingly.
I tried to use OFFSET with the combination of some Named ranges, but some how I am not clear on how to link the data to chart as well as building the correct formula.
Please help me. Thanks everybody.
InteractiveChart - Download - 4shared - farida perveen
mrxlsx
I have difficulty in building OFFSET formula to access my chart data dynamically. My data layout is as below.
State | FL | AZ | TX | ID |
Qty | xxx | xxx | xxx | xxx |
Sales | xxx | xxx | xxx | xxx |
Cost | xxx | xxx | xxx | xxx |
Profit | xx | xxx | xxx | xxx |
<tbody>
</tbody>
If I select any State in the cell A8, I should get the chart highlighting with all the Qty, Sales, Cost, Profit etc with the State name as the chart title. If I change the State in the drop down, data should change accordingly.
I tried to use OFFSET with the combination of some Named ranges, but some how I am not clear on how to link the data to chart as well as building the correct formula.
Please help me. Thanks everybody.
InteractiveChart - Download - 4shared - farida perveen
mrxlsx