Forum Discussion
PowerLord
Mar 27, 2021Copper Contributor
Trouble with Getting Data using Indirect from varying rows
I am going bonkers trying to set excel-up as per my requirements. I have attached my excel file here which is Office 365 version, Windows 10. My problems are: 1.) in the summary sheet, under Techn...
- Mar 29, 2021
There was some issue with links, so i turned it off
and it worked
so i did this dynamic charts, using sequence which uses ur first & last date in time frame & index & indirect, have a look at the sheet charts
in summary, i used just index, & last date from your time frame
chahine
Mar 29, 2021Iron Contributor
PowerLord your excel file is not working properly in formulas, so am not able to arrange it, maybe there are some formulas which are like loops
chahine
Mar 29, 2021Iron Contributor
There was some issue with links, so i turned it off
and it worked
so i did this dynamic charts, using sequence which uses ur first & last date in time frame & index & indirect, have a look at the sheet charts
in summary, i used just index, & last date from your time frame
- PowerLordMar 29, 2021Copper ContributorChahine,
Charts are still causing a problem. The chart plot data is different for each. For example, for OBV, the chart data is the Close Price, OBV and respective date. I entered this data many times but keeping getting a straight line for Close Price and weird pattern for OBV.- chahineMar 30, 2021Iron ContributorYou need to modify the chart tables based on your need, i used the columns that you told me about, but many of these columns are NA maybe i dont have the correct connection to some external files
for charts i did them like it will change based on your selection
- PowerLordMar 29, 2021Copper ContributorThank you very much Chahine! I will continue working and if I get stuck will post here again! Though I still am stuck on point no. 2, that is trying to get Excel to forecast, think you can help with that? THANK YOU!