Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 12
Default Creating A Chart that counts repitition (don't know name)

So, I feel like a moron not knowing this. But I must have had a brain freeze
for the last week.

I have a tableset of about 300 rows in Excel 2007 with one column being a
name and the other being a year. I want to create a graph of the years. IE
Y Axis = number of times a certain year appears in the tableset column and
the x axis being the years between (year k and year m).
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Creating A Chart that counts repitition (don't know name)

Sounds like a histogram. First you need to compile the data, then make a
chart of the compiled data. Here's how:
http://peltiertech.com/Excel/ChartsH...idateData.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Firebird" wrote in message
...
So, I feel like a moron not knowing this. But I must have had a brain
freeze
for the last week.

I have a tableset of about 300 rows in Excel 2007 with one column being a
name and the other being a year. I want to create a graph of the years.
IE
Y Axis = number of times a certain year appears in the tableset column and
the x axis being the years between (year k and year m).



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
Creating a chart(? pie chart) that shows customers,dates and machi Mark M Charts and Charting in Excel 1 August 20th 08 10:19 PM
average daily counts to weekly counts Dave Excel Discussion (Misc queries) 0 June 17th 08 06:24 PM
Label a chart of counts with other percentage data ragtopcaddy via OfficeKB.com Charts and Charting in Excel 0 June 17th 08 05:47 PM
How to group bars showing counts and overlay line compliance chart JaWeek Charts and Charting in Excel 4 May 15th 07 10:17 PM
Eliminating data repitition Graham Excel Discussion (Misc queries) 1 June 8th 05 03:26 PM


All times are GMT +1. The time now is 02:07 PM.

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

About Us

"It's about Microsoft Excel"