General Chat Thread, Help with Excel Chart in General; Got that Monday feeling and can't seem to get my head around this one. I have two columns of data,
9th November 2009, 11:31 AM #1
Help with Excel Chart
Got that Monday feeling and can't seem to get my head around this one. I have two columns of data,
Age at Death Total
giving ages people died at and how many of them died at that age. I want a histogram with the ages along the X and the total dies on the Y but can I get it! Don the usual highlighting both and selecting graph but don't seem to get a graph that I can select and age and cross reference it to the Y to see how many died at that age.
IDG Tech News
9th November 2009, 11:36 AM #2
1. Remove the header for age at death
2. Select all the data including the header row
3. Click on the chart wizard icon
4. Choose your chart
5. Click on next and label you axes, etc
6. Click on next and decide whether you want it as a separate tab or as an object on the worksheet.
Last edited by elsiegee40; 9th November 2009 at 11:40 AM.
Thanks to elsiegee40 from:
TechSupp (9th November 2009)
9th November 2009, 11:52 AM #3
Don't know what I was doing wrong! Thanks for that
9th November 2009, 12:19 PM #4
Originally Posted by TechSupp
It doesn't work if you have a column header for Age at Death as it assumes the numerical ages are to be used as data for the graph.
The simplest way to get round this is to remove the age column header and then use the chart wizard
By DaveP in forum Jokes/Interweb Things
Last Post: 15th March 2011, 05:37 PM
By econtent in forum Windows
Last Post: 21st April 2009, 04:30 PM
By kennysarmy in forum Windows
Last Post: 12th December 2008, 07:04 PM
By vunsev in forum Educational Software
Last Post: 4th June 2008, 09:17 AM
By wesleyw in forum How do you do....it?
Last Post: 12th September 2007, 11:01 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)