Lines to x and y axis of a data of a series (graph)

**zapotek** · 04-05-2013, 10:40 AM

hi;

at excel graphs; how can we draw line to x and y axis for a data of a series? for example my series has a data (x,y) = (5,10)
I want to draw lines from this point to x and y axises.
Thanks...

**Andy Pope** · 04-05-2013, 10:43 AM

if the chart is a xy-scatter you can use minus 100% error bars

**zapotek** · 04-05-2013, 10:55 AM

hi;

that worked. Thank you so much...

**zapotek** · 04-05-2013, 11:27 AM

Sorry Andy;

i want to ask a new question about this. there are 8 different data on my series. I don't want to show all datas' bars. Can i delete or eliminate the other datas' error bars?

**Andy Pope** · 04-06-2013, 05:44 AM

Either add a series with just the relevant data point.
Or use custom error bar values, which has no data for all data points not requiring drop lines.