Drop line on only one data point in series

[nasdone]

Is it possible to add a drop line to only one data point in a series? If so,
how? I believe attaching an autoshape line to a single data point would also
meet my needs. I would like to be able to have a single data point marked
with a line that doesn't require repositioning every time I add new points to
the end of the series, which is daily. Any ideas?

 

[Jon Peltier]

An autoshape would move anytime a heavy truck drove by. You could add custom
negative error bars to the series, where the range containing the values
contained zero for each point except for the one you want the drop line for.
Easier might be to add a series with blank or #N/A values for all points
except the one with the drop line, then add a negative error bar with a
percentage value of 100%. Format the added series so it has no lines or
markers.

- Jon

 

[Del Cotter]

Is it possible to add a drop line to only one data point in a series? If so,
how? I believe attaching an autoshape line to a single data point would also
meet my needs. I would like to be able to have a single data point marked
with a line that doesn't require repositioning every time I add new points to
the end of the series, which is daily. Any ideas?

When drop lines are on, they work for all points in all series, which is
not what you want.

Have you considered a 100% minus error bar? That still only works with
all points in one series, but you can create a second series with just
that one point in it, a visible "minus 100%" error bar, and an invisible
data marker.

Or *not* invisible, if you prefer: then, the data marker with the drop
line will stand out, apart from by having a drop line.

 

[nasdone]

Thanks. I used your second option and it works great. It took a moment to
figure out how to format the one point series function, but I resolved it.