Way to input chart data range through value in cell

[chielvandijk]

Hello,

I'll get straight to my problem.
I have a sheet filled with graphs and one dropdown menu (7 menu options).
Another sheet is filled with values per category (one graph per category in the other sheet) and also contains one dropdown menu (with the same link as the one in the other sheet).
Each of the menu options from the dropdown causes the values to change, which it also does in the graphs.
But because every menu options causes the amount of values along the x-axis to change, I need my chart's data range to change as well.
In a third sheet I have formulas (generated through the dropdown link number) which calculate the range.
I need a way (dynamic range, or VBA for instance) to get this range as my graph's data range, instead of the cell in which the range can be found becoming the range. And the range needs to change along with the formula's output change when the dropdown menu is changed.

I hope someone will be able to help me.


Michiel

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/excel-questions/910899-chart-data-range-based-value-range-cell.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rules # 12 here: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html).