Dynamic Chart with Years in Series (Legends)

[meami111]

Hello I want to create a Dynamic Chart which is having Years as Series (Legends) and Functions as Horizontal Axis Labels (Categories). I am unable to include one named range in the series part. Please help

 

[Hui]

It can't be done for what you want
The easiest way to manually do it is top select the chart
Click on the plot area until the Chart data is shown
Then drag the small Lower Right square across one cell

 

[meami111]

Thanks a lot for the quick revert. Do you suggest any alternative way so that manual dragging can be done away with?

 

[GraH - Guido]

Convert your range into a table and make a chart referring to the table. Adding data to the right makes the table grow and should extend the chart too.