Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining Data on a pie chart | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
Flip the X and Y data on a chart so that the Y data is vertical. | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |