Forum Discussion
selecting columns
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
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.