High-Low Lines not available
 

Hi I'm using Excel 2003 and trying to use H-L lines for the first time. I
select the series, get to Format Selected Series/Options but there's no
High-Low box to click (there is one for Series Line, but it's greyed out).

Any ideas, please?

High-Low Lines not available
 

What kind of chart? High-Low Lines and Up-Down bars are available for Line
charts. Series Lines are available I believe for stacked column charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"GeoffA" wrote in message
...
Hi I'm using Excel 2003 and trying to use H-L lines for the first time. I
select the series, get to Format Selected Series/Options but there's no
High-Low box to click (there is one for Series Line, but it's greyed out).

Any ideas, please?

High-Low Lines not available
 

Thanks Jon. I see now as I'm trying to do stacked bar chart and it's not
available. I think I can get around by showing 2 bars (one no colour) and a
series of points- if not I'll come back

Thanks again

Geoff

"Jon Peltier" wrote:

What kind of chart? High-Low Lines and Up-Down bars are available for Line
charts. Series Lines are available I believe for stacked column charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"GeoffA" wrote in message
...
Hi I'm using Excel 2003 and trying to use H-L lines for the first time. I
select the series, get to Format Selected Series/Options but there's no
High-Low box to click (there is one for Series Line, but it's greyed out).

Any ideas, please?

High-Low Lines not available
 

Ah I see - I'm using bars for this chart due to length of descriptions.

"Jon Peltier" wrote:

What kind of chart? High-Low Lines and Up-Down bars are available for Line
charts. Series Lines are available I believe for stacked column charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"GeoffA" wrote in message
...
Hi I'm using Excel 2003 and trying to use H-L lines for the first time. I
select the series, get to Format Selected Series/Options but there's no
High-Low box to click (there is one for Series Line, but it's greyed out).

Any ideas, please?