| 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 | |||
Linear Mode
