ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Creating A Chart that counts repitition (don't know name) (https://www.excelbanter.com/charts-charting-excel/205056-creating-chart-counts-repitition-dont-know-name.html)

Firebird

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).

Jon Peltier

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).





All times are GMT +1. The time now is 06:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com