selecting columns

%3CLINGO-SUB%20id%3D%22lingo-sub-2711002%22%20slang%3D%22en-US%22%3Eselecting%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2711002%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EIm%20trying%20to%20select%20more%20than%20one%20column%20to%20convert%20into%20a%20chart.%20However%20the%20columns%20are%20not%20directly%20next%20to%20one%20another%20and%20I%20need%20help%20in%20doing%20this.%3C%2FP%3E%3CP%3EIs%20it%20even%20possible%3F%3C%2FP%3E%3CP%3ETIA%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2711002%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2711200%22%20slang%3D%22en-US%22%3ERe%3A%20selecting%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2711200%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1144408%22%20target%3D%22_blank%22%3E%40Mo1975%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECreate%20a%20chart%20based%20on%20the%20first%20column.%3C%2FP%3E%0A%3CP%3EClick%20anywhere%20in%20the%20chart.%3C%2FP%3E%0A%3CP%3EIn%20the%20Data%20group%20of%20the%20Chart%20Design%20tab%20of%20the%20ribbon%20(or%20Design%2C%20under%20Chart%20Tools%2C%20depending%20on%20your%20version%20of%20Excel)%2C%20click%20Select%20Data.%3C%2FP%3E%0A%3CP%3EUnder%20Legend%20Entries%20(Series)%2C%20click%20Add%20and%20specify%20another%20column%20in%20the%20Series%20Values%20box.%3C%2FP%3E%0A%3CP%3ERepeat%20as%20needed.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

1 Reply

@Mo1975 

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.