| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple series in a scatter chart | Charts and Charting in Excel | |||
| Is it possible to drag points in an Excel 2007 Scatter Chart? | Charts and Charting in Excel | |||
| multiple data series in an x-y scatter chart - Excel 2003 | Charts and Charting in Excel | |||
| How to Draw a chart line connecting 2 points in the middle of the series | Charts and Charting in Excel | |||
| how to put connecting line between data points on scatter chart? | Charts and Charting in Excel | |||
Hybrid Mode
