Special charts
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.
|