On Mon, 9 Jun 2008, in microsoft.public.excel.charting,
Jon Peltier said:
"jgiampie" wrote
The data are contiguous in my spreadsheet. When I put an eleventh
data point in the row, say the time 8:55 PM, rather than graphing
that point, it graphs a yellow triangle at the tip of the bar
seeming to show the point past which it won't graph any more points.

It's a bar chart? I guess I don't see how your data is turned into chart
series.

I believe he's using the custom chart type "Line-Column on 2 Axes". Each
data point is a different series, and the tenth series is where it stops
being bars and starts being lines, and the eleventh series, the first
line series, does indeed have as its default format symbol a yellow
triangle.

James, since you are graphing point events (deliveries) in time rather
than the length of time since the start of the day, may I suggest you
abandon bars and simply go for points, in what William S. Cleveland
calls a "point graph"? You could use the wizard to create a point graph
the way you're doing it, by simply choosing chart type "Line Chart",
then formatting all the ranges to be the same symbol and no line.

This would be very inelegant, mind, as the underlying structure would be
a series for every point, with a limit of 255 points. If you decide to
go for this, then F4 would be your friend as you format the first series
and step through all subsequent ones pressing the F4 key to repeat the
last action.

There are ways to conserve series, but they require a bit of
sophistication, and, in a twist that may have come back to bite some of
us purists, the old gibe "there is no shortage of cells, you don't have
to conserve them!" can be adapted. That is, if you know your delivery
workers will never make 255 deliveries, we can say "there is no shortage
of series, you don't have to conserve them!"

(in any case, if your table runs from left to right, you'll run out of
spreadsheet columns before you get to 255 anyway)

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.