Hi, Zack,
Try using a bar chart as the chart type. (Note: If you
don't want your timelines to look as fat as typical bars,
make them thinner by increasing the 'Gap Width' in
Format, Data Series, Options).
There are several ways you could do this, but the reason
I suggest a bar chart is that the x and y axes are
swapped in a bar chart -- so that the horizontal axis is
actually your value axis. Basically, a bar chart will sit
the data you have now on its side, so to speak, so that
it looks like what you want.
More detail on how to set this up below, but just in case
you'd like some explanatory info on the way the axes are
working ... For charts like columns, bars, and lines -
the Y-axis is the value axis and the x-axis is the
category axis (the category axis would be the time-
scale). But, you're setting up your data with your
durations as the values -- so they're plotted on the y
(value) axis (that's why they appear vertical). There are
chart types that will give you a value axis for both the
x and y axes (scatter charts), but that's going to be a
more complex solution that I think you need.
If you use the data just like you have it set up now, but
create a bar chart -- I suspect it will easily give you
exactly what you're looking for. When you create the
chart -- you'll want each item (sounds like you already
have it this way) to be its own data series. If your data
looks something like this:
item 1 3
item 2 -2
item 3 5
Then, you'll want to select the option for 'Series in
Rows' in step 2 of the chart wizard "Chart Source Data".
Typing your duration values as positive or negative
numbers is all you need to do to get them to show up
above or below the horizontal axis with a bar chart.
That should do the trick.
Hope it helps!
Stephanie Krieger
author of Microsoft Office Document Designer
email: MODD _ 2003 at msn
blog: arouet.net
-----Original Message-----
I'm trying to create a "time-line" chart on both sides of the X axis.
For example, item '1' lasts (3) seconds long and is 'positive' (above X
axis). Item '2' lasts (2) seconds and is 'negative' (below X axis). Item
'3' lasts (5) seconds and is 'positive'. Every time I graph this the lengths
of the items are graphed vertically instead of
horizontally. Any suggestions?
