armchairandy
Board Regular
- Joined
- Mar 27, 2012
- Messages
- 53
Hi<o
></o>
<o></o>I have a spread-sheet in which one of the rows is a summaryof columns: ie row 10 each cell from A10 to ZZ10 is a sum of the values in Rows 2 to 9, ie Cell A10 is the sum of A2 to A9, and soon. the formulas are from A10 to ZZ10. Row 1 A1 to AZZ are dates. So A10 is thesum of all the values for the date in A1. The data in row 10 has not gotnumbers in all the columns as there would be some zeros via the formula. Because of the formulas none of the cells are blank.
The purpose is to produce a spread-sheet and chart which dynamically changes when the dates and values changes.<o></o>
What I am trying to do is create a graph using dynamicranges for the date row and data row 10 which starts and stops at when the datastarts and stops along row 10, ie the data I want to chart might start atcolumn F and finish at column N - I do not want the data (which will havereturned zero) in columns A to E or past N. Also I would expect the chart onlyto plot the timescale to suit.<o></o>
<o></o>
All of the cells have a formula in it, there are no blankcells.<o></o>
<o></o>
I hope this makes sense<o></o>
<o></o>
Regards<o></o>
></o><o
></o>I have a spread-sheet in which one of the rows is a summaryof columns: ie row 10 each cell from A10 to ZZ10 is a sum of the values in Rows 2 to 9, ie Cell A10 is the sum of A2 to A9, and soon. the formulas are from A10 to ZZ10. Row 1 A1 to AZZ are dates. So A10 is thesum of all the values for the date in A1. The data in row 10 has not gotnumbers in all the columns as there would be some zeros via the formula. Because of the formulas none of the cells are blank. The purpose is to produce a spread-sheet and chart which dynamically changes when the dates and values changes.<o
></o>What I am trying to do is create a graph using dynamicranges for the date row and data row 10 which starts and stops at when the datastarts and stops along row 10, ie the data I want to chart might start atcolumn F and finish at column N - I do not want the data (which will havereturned zero) in columns A to E or past N. Also I would expect the chart onlyto plot the timescale to suit.<o
></o><o
></o>All of the cells have a formula in it, there are no blankcells.<o
></o><o
></o>I hope this makes sense<o
></o><o
></o>Regards<o
></o>
