Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a chart(? pie chart) that shows customers,dates and machi | Charts and Charting in Excel | |||
average daily counts to weekly counts | Excel Discussion (Misc queries) | |||
Label a chart of counts with other percentage data | Charts and Charting in Excel | |||
How to group bars showing counts and overlay line compliance chart | Charts and Charting in Excel | |||
Eliminating data repitition | Excel Discussion (Misc queries) |