Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
|
|||
|
|||
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:
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data point on line is not over the point/tick in X axis... | Charts and Charting in Excel | |||
Including data in data table but not charting as a series or point | Charts and Charting in Excel | |||
Single Data Point on a new Series | Charts and Charting in Excel | |||
How do I set different error bars per data point in a series | Charts and Charting in Excel | |||
show the value of the last point of every series, in Excel line ch | Charts and Charting in Excel |