View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Tammy Tammy is offline
external usenet poster
 
Posts: 145
Default 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!