Sep 02 2021 03:11 AM
Hi
Im trying to select more than one column to convert into a chart. However the columns are not directly next to one another and I need help in doing this.
Is it even possible?
TIA
Sep 02 2021 04:14 AM
Create a chart based on the first column.
Click anywhere in the chart.
In the Data group of the Chart Design tab of the ribbon (or Design, under Chart Tools, depending on your version of Excel), click Select Data.
Under Legend Entries (Series), click Add and specify another column in the Series Values box.
Repeat as needed.