| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Using drop lines with XY scatter chart
I want to use the drop lines with a XY scatter chart, but unfortunately that
option is not available under 'Format Data Series'----'Options'. I know that this drop line option is available with other chart types like 'Line', problem is I can't use the Line chart type since it can't correcty represent my data set. I want a workable solution. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Using drop lines with XY scatter chart
XY charts don't have drop lines, but you can substitute an error bar. Double
click on the series, click on either Error Bar tab, and select a negative error bar, select the Percentage option, and enter 100%. If the axes still intersect at (0,0), 100% is the distance from each point to the axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "SMACS03" wrote in message ... I want to use the drop lines with a XY scatter chart, but unfortunately that option is not available under 'Format Data Series'----'Options'. I know that this drop line option is available with other chart types like 'Line', problem is I can't use the Line chart type since it can't correcty represent my data set. I want a workable solution. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scatter chart without numerical values | Charts and Charting in Excel | |||
| Line chart or scatter chart?? | Excel Discussion (Misc queries) | |||
| Line chart or scatter chart?? | Excel Discussion (Misc queries) | |||
| Leader Lines Connecting Chart to Box | Excel Discussion (Misc queries) | |||
| Leader Lines Connecting Chart to Box | Charts and Charting in Excel | |||
Linear Mode
