Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
TAMM
 
Posts: n/a
Default how do i plot this kind of data using excel

need a help in plotting data presented in class form, e.g; variables for A in
condition 1 ranges from 67-89, in condition 2they range from 52-67, in
condition 3; 65-87, in conditon 4, 62-83.
Variables for B in condition 1 60-77,in condition 2, 50-64, in condition 3,
54-73, in condition 4 51-70
  #2   Report Post  
John Mansfield
 
Posts: n/a
Default

Tamm,

Try setting your data up like this:

Low High
A1 67 89
B1 60 77
A2 52 67
B2 50 64
A3 65 87
B3 54 73
A4 62 83
B4 51 70

Then, plot it using either a clustered column chart or a stacked column chart.

----
Regards,
John Mansfield
http://www.pdbook.com



"TAMM" wrote:

need a help in plotting data presented in class form, e.g; variables for A in
condition 1 ranges from 67-89, in condition 2they range from 52-67, in
condition 3; 65-87, in conditon 4, 62-83.
Variables for B in condition 1 60-77,in condition 2, 50-64, in condition 3,
54-73, in condition 4 51-70

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM
How do I plot data on a map in excel Byron Charts and Charting in Excel 3 January 19th 05 08:01 PM
Charting Data from Excel DavidM Charts and Charting in Excel 4 December 30th 04 02:31 PM
multiple or changing colours in a data table on an excel chart fo. Kerri Buxton Charts and Charting in Excel 2 December 23rd 04 07:39 PM
How do I plot data in Excel that is captured on separate sheets; . krwegner Excel Discussion (Misc queries) 0 November 30th 04 05:43 PM


All times are GMT +1. The time now is 10:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"