kh40sth30ry
New Member
- Joined
- May 8, 2011
- Messages
- 9
Hi all,
So recently i attempted to make interactive chart. My example is the S&P/TSX volume and date. The idea is i can choose a start date and a preiod of time, then the chart will be updated. (see Screenshot)
The Name of the array to update the chart is "ShowPrice" and "Month". I want to display a table that print out the values of the two array right beneath the chart (i will move the raw data on the left of the chart to a separate sheet). I have an general idea of displaying the values corresponding to the chart using
and drag it out for the entire row. However, i just wonder is there is a better way to print out the table that display values corresponding to the chart as the chart updated (maybe using array formula). I am hoping for a way to do it with just excel formula, but open to macro as well.
Thank you.
So recently i attempted to make interactive chart. My example is the S&P/TSX volume and date. The idea is i can choose a start date and a preiod of time, then the chart will be updated. (see Screenshot)
The Name of the array to update the chart is "ShowPrice" and "Month". I want to display a table that print out the values of the two array right beneath the chart (i will move the raw data on the left of the chart to a separate sheet). I have an general idea of displaying the values corresponding to the chart using
Code:
= VALUE(INDEX(ShowPrice, 1))
and = VALUE(INDEX(Month, 1))Thank you.
