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
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.
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