PC Review


Reply
Thread Tools Rate Thread

Creating A Chart that counts repitition (don't know name)

 
 
Firebird
Guest
Posts: n/a
 
      4th Oct 2008
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 With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      4th Oct 2008
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" <(E-Mail Removed)> wrote in message
news:8917B452-03AD-4FAD-BE79-(E-Mail Removed)...
> 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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Creating a printed report containing multiple counts XPS35 Microsoft Access Reports 1 19th May 2010 02:47 PM
Creating report with date counts Chipgiii Microsoft Access 1 10th Feb 2010 07:00 PM
Creating queries asking for counts John Microsoft Access Queries 6 4th Dec 2009 08:46 PM
Counts By Month To Chart? Roger Tregelles Microsoft Access Queries 1 10th Oct 2006 01:50 AM
Creating a formula that counts occurances =?Utf-8?B?c21vdXRzYXQ=?= Microsoft Excel Discussion 2 8th Dec 2005 08:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:57 AM.