|
Applications Use this board for problem solving and the discussion of computer software applications |
|
Topic Tools |
#1
|
|||
|
|||
Excel Chart Help
Alright this may be confusing at first but please read. I am creating a line plot of the measurements of leaves. I would like the frequency to be on the y axis, and the leaf length to be on the x axis. I truly do not feel like going through hundreds of measurements and find out how frequently they occur, so can someone tell me how to make this chart the way i want it. Your help is greatly appreciated!
Ex: i have measurements from 3 cm - 6 cm. I would like for the x axis to have numbers 1-10 and the y axis to have the frequency |
#2
|
||||
|
||||
Say you have the leaf lengths in A1 to A100. In column B, put the intervals you want on the graph - 1 to 10, let's say these will be in B1:B10. Now, highlight the cells in column C adjacent to the intervals (C1:C10). In the formula bar, enter:
Code:
=FREQUENCY(A1:A100,B1:B10) Last edited by oracle128; March 1st, 2007 at 12:30 PM. |
Bookmarks |
«
Previous Topic
|
Next Topic
»
Topic Tools | |
|
|
Similar Topics | ||||
Topic | Topic Starter | Forum | Replies | Last Post |
How to change the date range in an Excel 2010 chart | Kirk1 | Applications | 3 | May 29th, 2013 01:01 AM |
Cannot create a line chart in Excel 2007 | Fortunate | Applications | 0 | May 27th, 2009 03:36 PM |
The x-axis of a bar chart in Excel is not in order | Fortunate | Applications | 7 | June 6th, 2008 10:16 AM |
Challenge...Excel Chart to Power Point | calculus87 | Applications | 2 | July 1st, 2004 03:10 AM |
Color chart | Bill | Web Development & Graphic Design | 8 | November 8th, 2000 09:00 PM |
All times are GMT +1. The time now is 01:09 PM.