Charts

  • Thread starter Thread starter News Groups
  • Start date Start date
N

News Groups

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
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?
Click to expand...
 
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.
 
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
 
Back
Top