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

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

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
>
>