Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Donna
 
Posts: n/a
Default 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   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining Data on a pie chart Mark C Charts and Charting in Excel 3 December 17th 04 08:11 PM
Charting data ranges that change mikelee101 Charts and Charting in Excel 2 December 17th 04 12:07 AM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 09:05 PM
Flip the X and Y data on a chart so that the Y data is vertical. Haynesz Charts and Charting in Excel 1 December 3rd 04 02:14 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 04:30 AM


All times are GMT +1. The time now is 01:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"