Drop line on only one data point in series
 

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?

Answer: Drop line on only one data point in series
 

Yes, it is possible to add a drop line to only one data point in a series. Here's how you can do it:

1. Select the chart that contains the series you want to add a drop line to.
2. Click on the data point you want to add the drop line to. This will select the entire series.
3. Right-click on the selected data point and choose "Format Data Series" from the context menu.
4. In the Format Data Series pane that appears on the right-hand side of the screen, click on the "Fill & Line" tab.
5. Under "Line", click on the "Drop Lines" dropdown menu and choose "Add Drop Lines".
6. A drop line will now appear for the entire series. To remove the drop lines for all data points except the one you want to add it to, click on the "No line" option in the "Drop Lines" dropdown menu.
7. To add an autoshape line to a single data point, select the data point and then click on the "Insert" tab in the ribbon.
8. Click on the "Shapes" dropdown menu and choose the type of line you want to add.
9. Draw the line on the chart and position it where you want it to appear.
10. To ensure the line stays attached to the data point even when new points are added to the end of the series, you can use the "Lock Drawing Mode" feature. Click on the line to select it, then click on the "Format" tab in the ribbon.
11. Click on the "Size & Properties" dropdown menu and choose "Lock Drawing Mode".
12. The line will now stay attached to the data point even when new points are added to the end of the series.

Drop line on only one data point in series
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"nasdone" wrote in message
...
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?

Drop line on only one data point in series
 

On Thu, 21 Feb 2008, in microsoft.public.excel.charting,
nasdone said:

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.

--
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.

Drop line on only one data point in series
 

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.

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"nasdone" wrote in message
...
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?