Special charts

LookingForAnswers · #1 06-16-2011, 12:54 PM

Hi,

I have Excel 2008 for MAC. I am trying to create a chart from data in only one column of my Excel Spreadsheet. Here's the scenario broken down:
1. In each cell of column "C" I have a value usually between 0 and 100.

2. There are 6,000 rows of data, so the number 15 may appear 100 different times within Column C; the number 25 may appear 125 different times, etc.

3. I would like to create a line chart that plots how many times each number appears in Column C. The X axis would represent 0 through 100 (days). The Y axis would represent the number of times each number in Column C appears (the values in Y Axis should be between 0 and 1,000)

Thank you so much. I look forward to hearing from you.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
paste special default	croy	Word	2	03-20-2011 04:29 AM
special formatting	w.learning	Word	0	02-28-2011 10:56 AM
special copy/paste	iconofsin	Excel	1	09-15-2010 12:10 AM
Copy and paste special	Dace	Excel	2	02-16-2009 12:18 PM
Creating a special Document	darka5sa5sin	Word	0	02-06-2009 11:23 AM