Charts

Hi. Running Excel 2003 on XP Pro. All works well. Is there a way to
display my x-axis labels on top of the chart instead of below the chart? Or
can I do both?

TIA

John

Double-click the x-axis
On the Patterns tab, under Tick Mark labels, select High
Click OK

News Groups wrote:
> Hi. Running Excel 2003 on XP Pro. All works well. Is there a way to
> display my x-axis labels on top of the chart instead of below the chart? Or
> can I do both?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

to show an x axis on both top and bottom, if you have two data sets, select
one of them and set axis as secondary. goto chart options and select axis
show secondary x axis
If you have only one data set plot a dummy data point set the secondary axis
and then select the dummy line and make the line and symbol pattern be none.
If you are using a legend, select the entry for the dummy legend and use edit
clear all to hide the legend entry.

"News Groups" wrote:

> Hi. Running Excel 2003 on XP Pro. All works well. Is there a way to
> display my x-axis labels on top of the chart instead of below the chart? Or
> can I do both?
>
> TIA
>
> John
>
>
>

bj,

Thanks so much. It worked *perfectly*

John


"bj" <[email protected]> wrote in message
news:[email protected]...
> to show an x axis on both top and bottom, if you have two data sets,
> select
> one of them and set axis as secondary. goto chart options and select axis
> show secondary x axis
> If you have only one data set plot a dummy data point set the secondary
> axis
> and then select the dummy line and make the line and symbol pattern be
> none.
> If you are using a legend, select the entry for the dummy legend and use
> edit
> clear all to hide the legend entry.
>
> "News Groups" wrote:
>
>> Hi. Running Excel 2003 on XP Pro. All works well. Is there a way to
>> display my x-axis labels on top of the chart instead of below the chart?
>> Or
>> can I do both?
>>
>> TIA
>>
>> John
>>
>>
>>

Debra,
Thanks for responding. I tried changing from the default "Next to Axis" to
"High" but nothing happened. I also tried "None" which made the axis
disappear (as it should) and "low" which kept the axis at the bottom (also
makes sense). So, they all seem to work except "High." Oh well. I ended
up making it work by adding a "secondary axis."

Thanks.

John

"Debra Dalgleish" <[email protected]> wrote in message
news:[email protected]...
> Double-click the x-axis
> On the Patterns tab, under Tick Mark labels, select High
> Click OK
>
> News Groups wrote:
>> Hi. Running Excel 2003 on XP Pro. All works well. Is there a way to
>> display my x-axis labels on top of the chart instead of below the chart?
>> Or can I do both?
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>