Last entreis in graphs

[shafiq_eng]

Dear Frieds

I create monthly graphs for plant production for the last six months each time. Is it possible to have the last six months graph when I enter data for seventh eights or so on data without changing source data in graphs.



shafiq

 

[acw]

Hi

It is possible. There are various ways.

One is to have the graph connected to a fixed range, and then populate that fixed range with the last 6 months of data dynamically.

Another is to have the graph based on a named range, and have that range name change dynamically.


Tony

 

[shafiq_eng]

Hi Tony


How do I do that?


shafiq

 

[acw]

Hi

For the first one:

1) Assume that the source data is in the range C1:N2 with the headings in row 1 and the data in row 2. Fill cells C2 to H2 with data.

2) In A2 enter the formula
=COUNTA(C2:N2)

3) In C6 enter the formula
=OFFSET($B$1,0,$A$2+(COLUMN()-8))
and copy across to H6

4) In C7 enter the formula
=OFFSET($B$2,0,$A$2+(COLUMN()-8))
and copy across to H7

5) The graph data is in the range C6 to H7

6) Put new data in the source range (I2) and the graph range data will auto update.


Tony


headings are in the range