Graph Variable Range

[duplaly]

Good evening

I am looking to automate the data range for the 2 graphs in my file.

Situation 1

Graph Recovery must feed from the last filled column at all times. When I go to fill in the "H" column, the graph should adjust automatically

Situation 2

Annual trend graph

How do I define a dynamic range on the columns for the yearly trend graph that will adjust as I enter data in the subsequent columns "H1 and H2", etc.?

Thanks for your time and help in advance!

[josephteh]

Create the named-ranges below and use them as the data sources for the charts:

Chart 1
AxisLabel1 =OFFSET($A:$A,2,0,COUNTA($A:$A)-2)
SeriesValues1 =OFFSET($A$3:$A$23,0,COUNTA($1:$1)-1)

Chart 2
AxisLabel2 =OFFSET($1:$1,0,1,1,COUNTA($1:$1)-1)
SeriesValues2 =OFFSET($2:$2,0,1,1,COUNTA($1:$1)-1)

[duplaly]

Hello Sir
This is amazing and i really appreciate your help.
By the same time, could help me to do the same with the chart "Recovery per Site"

[josephteh]

Please refer to workbook attached in post#2.

[duplaly]

Hello
The Workbook in post #2 doesn't contain the new chart I'm asking for help

Tks

[josephteh]

Sorry, I have no idea how to get your third graph to work. Maybe other members can help.