Forum Discussion
Solved
Charts
Hi, I am using 15 minute intraday data to make charts with the following columns time, open, high, low and close is there anyway I can copy the chart down the row and the chart will grab the next data series ??? its alot of data and excel keeps asking me to select the data range thanks
- I would create one chart which allows you to select the section of the data you want it to display. For that, create a separate area in your spreadsheet that holds the data for the chart. Use formulas to pull the correct section of the data for the chart into that separate area.
- I would create one chart which allows you to select the section of the data you want it to display. For that, create a separate area in your spreadsheet that holds the data for the chart. Use formulas to pull the correct section of the data for the chart into that separate area.
JKPieterse thanks
