If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart from data occurrances
I need to make a chart on how many times the data in one column occurs.
There doesn't seem to be a chart built into excel that does that. I'm kind of desperate, so if anyone has any idea I would REALLY appreciate the help. Thanks! Donna |
#2
|
|||
|
|||
You can summarize the data with a Pivot Table, and create a chart from that.
Add a heading to the list of items, e.g. Code Select a cell in the list Choose DataPivotTable and PivotChart Report Select PivotChart report (with PivotTable report), click Next Select the Data range, click Next Click Layout Drag the Code button to the Row area Drag Code again to the data area, where it will become Count of Code Click OK, click Finish A column chart will be created. To change it to a different chart type, select the chart and choose ChartChart Type. Donna wrote: I need to make a chart on how many times the data in one column occurs. There doesn't seem to be a chart built into excel that does that. I'm kind of desperate, so if anyone has any idea I would REALLY appreciate the help. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Chart menu visible property | Sandy V | Charts and Charting | 8 | May 17th, 2004 01:39 PM |
chart with changing data source interactive chart | Feketik | Charts and Charting | 1 | March 19th, 2004 09:26 AM |
Pivot Chart affected when refresh data | Ailing | Charts and Charting | 1 | January 15th, 2004 11:20 AM |
Cell reference data not displaying in chart | Jon Peltier | Charts and Charting | 0 | November 12th, 2003 06:30 PM |
Chart Data | Earl Kiosterud | Worksheet Functions | 0 | October 16th, 2003 03:25 PM |