how do you graph with year dates as IV1998, I 1999, etc

6angel9 · External Since: Sep 30, 2009 Posts: 1

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.

Gklass · External Since: May 26, 2006 Posts: 14

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 <6ang....TakeThisOut@discussions.microsoft.com> 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.