PC Review


Reply
Thread Tools Rate Thread

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

 
 
AndyN
Guest
Posts: n/a
 
      11th Jul 2008
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

 
Reply With Quote
 
 
 
 
Ed Ferrero
Guest
Posts: n/a
 
      11th Jul 2008
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


 
Reply With Quote
 
AndyN
Guest
Posts: n/a
 
      11th Jul 2008
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
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple data sets on the same graph Doug Microsoft Excel Programming 0 17th Dec 2009 11:17 PM
how do I plot two sets of data in the same graph? =?Utf-8?B?b2xsaWVzZg==?= Microsoft Powerpoint 1 12th May 2005 04:17 AM
How do I integrate 4 sets of data in a graph? =?Utf-8?B?MjUzOQ==?= Microsoft Excel Charting 3 16th Oct 2004 09:16 PM
Multiple Data Sets on Same Graph Chris Microsoft Excel Misc 1 30th Sep 2004 09:45 AM
Plotting a 2 sets of Y data in the X-Y same graph Gonzalo Garreton Microsoft Excel Charting 1 24th Sep 2004 07:00 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:53 PM.