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!

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!

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!

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!

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!