This post consists of 2 inter-related questions:
1. I have a column of data as below from which I wish to plot a chart of every nth row, using Excel's named range as my series. The named range should be where I should be able to enter a formula to pull data every nth row.
For example, if the data is arranged in column B, and I enter a value of 3 in cell C1, I want the chart to plot only data in the 1,3,7,10th row and so on...
So, from the above data range, if I entered 3 in cell C1, I want excel chart to plot the values 10,16, 24, 14 ....
One way of doing this is to first pull the value of every nth row into another column and then plot the chart using this new range. However, this is needless duplication of data, (and given that I will be plotting a no. of series and a no. of charts, this is creating a lot of duplication) and slowing my charts down.
How do I plot every nth row using Excel's named range as my series with a formula to define the values to be pulled in the series?
2. Another question is that if I entered 3, then I wish to sum up values for every 3 rows and then plot a column chart having sum of every 3 rows in a column.
For example, using the above data, my bars will be plotting values of 54 (10+26+18), 48 (16+20+12), 54 (24+5+25), 46 (14+9+23).....
Is this also possible with named range as my series with a formula to define the values to be pulled in the series?
Sample file attached.