Forum Discussion
Solved
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...
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
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
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,
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.- You 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
- Thank 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!
