Separate line graphs for each row

[clinical]

Dear Experts,

I have following type of data.

Names	Jan-2021	Feb-2021	Mar-2021
John	55	65	70
Peter	1050	2070	1500
Hyde	8	7	3

I am looking for an easy option to plot line charts for each row (Names - Months). If there are 3 rows, I want 3 different graphs. I have tried sparklines but it didn't suite my needs.

Any non-VBA solution will be much appreciated.

Thanks.

 

[Jon Peltier]

If you don't want VBA, you'll have to do it manually. But there are tricks to make it easier.

Make a chart for the first row. Apply all the formatting that you want, so it is perfect.

Copy the chart. Select the chart's outer border. Note that there are highlighted ranges in the worksheet. Drag the blue range by its edge so it highlights the next row down. The chart is now plotting this highlighted range. The red range should also move down. Repeat for the rest of the rows.