Chart for Horizontally Progressing Dynamic Data

[meami111]

Hello, I have a data set which progresses horizontally. Please suggest how to create a dynamic chart for the same. I am unable to include a named range in the Series (Legends) side but have done for horizontal axis. Please check the attached chart

 

[Saba Sabaratnam]

Hi

The easiest way to do this is to hide columns.

Create a table with all 12 months as shown below and graph it.

Then hide the columns that you do not want to graph. It is illustrated below.

Kind regards

Saba