Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linkingof charts in worksheets to cells | Excel Discussion (Misc queries) | |||
Can't create dynamic charts | Charts and Charting in Excel | |||
i need help automating, or at least simplifying, my charts | Charts and Charting in Excel | |||
How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
initial size of new charts | Charts and Charting in Excel |