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" wrote in message
...
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" wrote in message
...
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