Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default how do you graph with year dates as IV1998, I 1999, etc

I have an assignment where the years are 1 1998, iv 1998, ....IV1999, ect, my
data for it is normal like 100, 2323, stuff liek that but how would you grpah
that I am confused.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 51
Default how do you graph with year dates as IV1998, I 1999, etc

If you can do a line chart (rather than a scatter with lines) Excel
will accept the text for the X axis.

Otherwise, create a dummy series of numbers 1998 1998.25 1998.5
1998.75 for your quarter
and another dummy series2 with the Y-axis minimum values for each time
point.

Use the first dummy series as your X axis, but hide the axis

Then plot the second dummy series with just a "+" marker.
Use a chart labeller to label those data points with your original
I-1998 II-1998 ... range
place the labels below the markers

gary klass


On Sep 30, 6:06*pm, 6angel9 wrote:
I have an assignment where the years are 1 1998, iv 1998, ....IV1999, ect, my
data for it is normal like 100, 2323, stuff liek that but how would you grpah
that I am confused.


Reply
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
Combination Graph with current year and prior year sales JanW Charts and Charting in Excel 2 April 5th 07 09:20 PM
how do I convert a dates in a year quarters in a year? Linndek Excel Discussion (Misc queries) 2 May 11th 06 03:33 PM
If Year equals 1999 then multiply cell by x logan_48080 Excel Discussion (Misc queries) 3 October 5th 05 07:55 PM
2/3/1999 78 4/30/1999 87 86 Grant Excel Discussion (Misc queries) 0 September 7th 05 01:15 AM
round up a 1999 + 1999 to the nerest 100 = 2000 + 2000 Keith Lumley Excel Discussion (Misc queries) 1 February 10th 05 11:35 AM


All times are GMT +1. The time now is 12:22 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"