Hi,
attached with this post is the daily trading ranges for the DAX Cash Index that contains 2 worksheets (Dashboard & DAX). I have built a scrolling chart (on the Dashboard worksheet) that displays one year at a time then scroll through the data. It’s done in a 2 step process. You will see the formulas used in columns A,B,C,D on the Dashboard worksheet which references data from the DAX worksheet.
Note
Cells that contain formulas are highlighted green. Cell F4 on the dashboard adjusts the look back period so that price movement can be measured over any time frame. My data will always grow on the DAX worksheet show I need to keep everything dynamic. I have some formulas in the name manager.
My questions are...
1. can I build a scrolling chart that references data directly from the data in the DAX worksheet?
2. can the chart show a vertical line on the dates in cells DAX!F16 & DAX!G16?
3. can I reduce or increase the data shown on the chart by entering a value in a cell rather than hardcoding into a range. For example I might want to see 60 days of data or 1000 days of data and not just the current 260 days of data I show now?
See link..
https://dl.dropboxusercontent.com/u/60464004/DOA.xlsx
Any help or suggestions (for any aspect of this workbook) would be appreciated.
regards
GB
attached with this post is the daily trading ranges for the DAX Cash Index that contains 2 worksheets (Dashboard & DAX). I have built a scrolling chart (on the Dashboard worksheet) that displays one year at a time then scroll through the data. It’s done in a 2 step process. You will see the formulas used in columns A,B,C,D on the Dashboard worksheet which references data from the DAX worksheet.
Note
Cells that contain formulas are highlighted green. Cell F4 on the dashboard adjusts the look back period so that price movement can be measured over any time frame. My data will always grow on the DAX worksheet show I need to keep everything dynamic. I have some formulas in the name manager.
My questions are...
1. can I build a scrolling chart that references data directly from the data in the DAX worksheet?
2. can the chart show a vertical line on the dates in cells DAX!F16 & DAX!G16?
3. can I reduce or increase the data shown on the chart by entering a value in a cell rather than hardcoding into a range. For example I might want to see 60 days of data or 1000 days of data and not just the current 260 days of data I show now?
See link..
https://dl.dropboxusercontent.com/u/60464004/DOA.xlsx
Any help or suggestions (for any aspect of this workbook) would be appreciated.
regards
GB