Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ID High Values | Excel Discussion (Misc queries) | |||
Inserting Lines or Copying lines with formulas but without data | Excel Discussion (Misc queries) | |||
Vertical Lines on the Lines on 2 Axes Chart | Charts and Charting in Excel | |||
high and low value in a cell | Excel Discussion (Misc queries) | |||
high-low lines | Charts and Charting in Excel |