Separate line graphs for each row

clinical

New Member
Joined
May 12, 2021
Messages
2
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
Dear Experts,

I have following type of data.

NamesJan-2021Feb-2021Mar-2021
John556570
Peter105020701500
Hyde873
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.
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
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.
 
Upvote 0

Forum statistics

Threads
1,223,889
Messages
6,175,224
Members
452,620
Latest member
dsubash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top