LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
 
Posts: n/a
Default Age in X-axis Labels as "YY;MM" ??

Hi All,

I cannot, for the life of me, figure out how to get excel to chart some
data of in the format of year;month to represent an age. This is a
common convention in the humanities, but I can't make excel do it.

Bascially, I want to plot data like this on an X-Y scatter plot

1;8 40
1;9 50
1;10 40
1;11 33
1;12 44
2;00 21
2;12 64

Thanks for any help you could give!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I move the Category Axis labels outside of the Plot Area? Brian Shoun Charts and Charting in Excel 1 January 7th 05 05:42 PM
How do I set "y" axis to numbers and labels to percentages on my . BYBaby Charts and Charting in Excel 1 January 6th 05 06:29 PM
Y axis labels Deborah Charts and Charting in Excel 1 January 6th 05 02:31 PM
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 06:25 PM
Linking Axis Labels Neil Charts and Charting in Excel 2 December 5th 04 09:04 PM


All times are GMT +1. The time now is 09:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"