Creating a Chart on two columns of data (1 Viewer)

Hey there,

I have two columns of data, which i want to create a comparitive line chart from.

Column 1 - Local Sales
Column 2 - National Sales

Both columns contain 12 rows, consisting of numerical values for the 12 months of the year.

When i try to run a chart for this data, it will display the correct line for the first column, however the second column's line is at 100% (when it shouldn't be).

Have i done something wrong here?


Thanks everyone,

Tom

Have just resolved this myself.

Issue: i was highlighting Column 1 (months of year), Column 2 (figures for local sales) and column 3 (figures for national sales). I was also highlighting headers for Column 2 and Column 3, and have realised that if i DON'T select the headers, the graph works fine.

My bad