View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
AndyN AndyN is offline
external usenet poster
 
Posts: 3
Default 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