Excell 2003
if I have the frequency of occurance of something between 1900 and 1910
How do I set up the data to avoid getting a line for the years as well as the frequency. If I put iin year 1900, year 1901 on so on, then I get only one line. However if i don't put in year in the same cell as the year, then I get two line. Thanks, knut |
Excell 2003
Hi,
Simplest way is to give your data column a heading <blank Data 1900 12 1901 15 1902 25 etc Then when you select the range including the header excel will have a better chance of guessing what is data and what is category information. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Knut" wrote in message ... if I have the frequency of occurance of something between 1900 and 1910 How do I set up the data to avoid getting a line for the years as well as the frequency. If I put iin year 1900, year 1901 on so on, then I get only one line. However if i don't put in year in the same cell as the year, then I get two line. Thanks, knut |
All times are GMT +1. The time now is 09:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com