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
|
|||
|
|||
Connecting two series in a scatter chart - Excel 2007
Hello - I have a user who created a scatter chart. The chart contains two
series: "HO" and "PD" - the HO data point has a related PD data point. She would like to have Excel add a connector line from the HO data point to the corresponding PD data point. Is this possible? I apologize that I am not familiar with this type of chart, or the lingo, so please let me know what other information you would need to answer this question. We are using Excel 2007. Thanks very much! |
#2
|
|||
|
|||
Connecting two series in a scatter chart - Excel 2007
Hi,
Double-click one of the series, in the format series dialog box choose the Options tab, and check high-low lines If this helps, please click the Yes button Cheers, Shane Devenshire "Tammy" wrote: Hello - I have a user who created a scatter chart. The chart contains two series: "HO" and "PD" - the HO data point has a related PD data point. She would like to have Excel add a connector line from the HO data point to the corresponding PD data point. Is this possible? I apologize that I am not familiar with this type of chart, or the lingo, so please let me know what other information you would need to answer this question. We are using Excel 2007. Thanks very much! |
#3
|
|||
|
|||
Connecting two series in a scatter chart - Excel 2007
Hi Shane,
Thanks very much for your response. I'm using Excel 2007 - can't seem to find the "high-low" lines option in the Format Data Series dialog box. Any idea where it's hiding? Thanks, again! "Cheers," wrote: Hi, Double-click one of the series, in the format series dialog box choose the Options tab, and check high-low lines If this helps, please click the Yes button Cheers, Shane Devenshire "Tammy" wrote: Hello - I have a user who created a scatter chart. The chart contains two series: "HO" and "PD" - the HO data point has a related PD data point. She would like to have Excel add a connector line from the HO data point to the corresponding PD data point. Is this possible? I apologize that I am not familiar with this type of chart, or the lingo, so please let me know what other information you would need to answer this question. We are using Excel 2007. Thanks very much! |
#4
|
|||
|
|||
Connecting two series in a scatter chart - Excel 2007
Hi,
If the chart is really a xy-scatter then Hi-Low lines are not available. You can mimic the lines using Custom Error bars. You need to calculate the difference between each pair of Y values and use them as the Custom Error value. If the chart is actually a Line chart then you can use the built-in Hi-Low lines. Select one of the series and then Chart Tools Layout Analysis Lines Hi-Low Lines Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Tammy" wrote in message ... Hi Shane, Thanks very much for your response. I'm using Excel 2007 - can't seem to find the "high-low" lines option in the Format Data Series dialog box. Any idea where it's hiding? Thanks, again! "Cheers," wrote: Hi, Double-click one of the series, in the format series dialog box choose the Options tab, and check high-low lines If this helps, please click the Yes button Cheers, Shane Devenshire "Tammy" wrote: Hello - I have a user who created a scatter chart. The chart contains two series: "HO" and "PD" - the HO data point has a related PD data point. She would like to have Excel add a connector line from the HO data point to the corresponding PD data point. Is this possible? I apologize that I am not familiar with this type of chart, or the lingo, so please let me know what other information you would need to answer this question. We are using Excel 2007. Thanks very much! |
#5
|
|||
|
|||
Connecting two series in a scatter chart - Excel 2007
Thank you very much for your suggestions, Andy. I will test the options.
Really appreciate it! "Andy Pope" wrote: Hi, If the chart is really a xy-scatter then Hi-Low lines are not available. You can mimic the lines using Custom Error bars. You need to calculate the difference between each pair of Y values and use them as the Custom Error value. If the chart is actually a Line chart then you can use the built-in Hi-Low lines. Select one of the series and then Chart Tools Layout Analysis Lines Hi-Low Lines Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Tammy" wrote in message ... Hi Shane, Thanks very much for your response. I'm using Excel 2007 - can't seem to find the "high-low" lines option in the Format Data Series dialog box. Any idea where it's hiding? Thanks, again! "Cheers," wrote: Hi, Double-click one of the series, in the format series dialog box choose the Options tab, and check high-low lines If this helps, please click the Yes button Cheers, Shane Devenshire "Tammy" wrote: Hello - I have a user who created a scatter chart. The chart contains two series: "HO" and "PD" - the HO data point has a related PD data point. She would like to have Excel add a connector line from the HO data point to the corresponding PD data point. Is this possible? I apologize that I am not familiar with this type of chart, or the lingo, so please let me know what other information you would need to answer this question. We are using Excel 2007. Thanks very much! |
Thread Tools | |
Display Modes | |
|
|