Excel graph 3 sets of data. 2 sets as lines 1 as column?
 

I have data a bit like below, I am trying to do a graph, which shows the AFR
as columns for A-D, but I want 'water' and 'whole' as seperate lines to show
current scores across the graph. When I do the graph, I get two columns and 1
line. Does anyone know how to get to get the two lines?

A B C D
AFR 0.8 0.6 0.4 0.3
Water 0.5 0.5 0.5 0.5
Whole 0.3 0.3 0.3 0.3

Excel graph 3 sets of data. 2 sets as lines 1 as column?
 

Hi AndyN,

On the chart, select the second column, right-click, select Chart Type from
the context menu, select line chart.

Ed Ferrero
www.edferrero.com

Excel graph 3 sets of data. 2 sets as lines 1 as column?
 

Ed

Thanks for that worked a treat, I'll remember that one for future!

Cheers


Andy

"Ed Ferrero" wrote:

Hi AndyN,

On the chart, select the second column, right-click, select Chart Type from
the context menu, select line chart.

Ed Ferrero
www.edferrero.com