Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
how do I convert a dates in a year quarters in a year? | Excel Discussion (Misc queries) | |||
If Year equals 1999 then multiply cell by x | Excel Discussion (Misc queries) | |||
2/3/1999 78 4/30/1999 87 86 | Excel Discussion (Misc queries) | |||
round up a 1999 + 1999 to the nerest 100 = 2000 + 2000 | Excel Discussion (Misc queries) |