If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
mix chart types | Ken Murray | Powerpoint | 7 | April 28th, 2006 02:50 AM |
Scatter Chart with Smoothed Lines | rachsull | Charts and Charting | 4 | January 31st, 2006 06:18 PM |
Combination stock and scatter chart | ArtZ | Charts and Charting | 1 | January 8th, 2006 07:59 PM |
Scatter Chart Data Point Highlighting | rvExcelNewTip | Charts and Charting | 6 | January 8th, 2006 05:21 PM |
Pie chart with 'anchored' lines to text box | TOMB | Charts and Charting | 0 | May 4th, 2005 09:14 PM |