Use excel "chart data range" field to plot multiple series

mejohn

New Member
Joined
Jun 23, 2018
Messages
11
Hello,

I'd like to use excel's "chart data range" field in the "select data source" window to create the chart below with individual series, instead of having to enter one series at a time.
Is that possible?

Thanks in advance for your help.


ABCDE
1descriptorabcd
2time (x-axis)0123
3pressure (y-axis)4567

1597781442779.png


1597781616752.png
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,118,754
Messages
5,574,040
Members
412,565
Latest member
roberttaekim
Top