Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
value of y axis position
Hi, all,
After reversal of x axis, I moved y axis from right to left. However, value of the y axis appears inside of the chart, how can I move them outside. Many thanks. Billy |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
value of y axis position
Your statement is a little vague. If in Format - Axis, I use "Values in reverse order," it
moves the Y axis to the right side, but the Y labels appear outside the chart, not inside. Or I can use "Value (Y) axis crosses at maximum value, " which also moves the Y axis to the right side, but the axis labels are still on the outside. Try this. With the Y axis selected (click any y axis label), do Format - Axis. In the Patterns tab, there are radio buttons for putting the tick marks and labels on the inside or outside. -- Regards from Virginia Beach, Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Billy L" <Billy wrote in message ... Hi, all, After reversal of x axis, I moved y axis from right to left. However, value of the y axis appears inside of the chart, how can I move them outside. Many thanks. Billy |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
value of y axis position
Thanks Virginia.
Problem has been resolved after I checked "high" on tick marks label. I was overlooked this since it appears as "high" rather than "ouside" "Earl Kiosterud" wrote: Your statement is a little vague. If in Format - Axis, I use "Values in reverse order," it moves the Y axis to the right side, but the Y labels appear outside the chart, not inside. Or I can use "Value (Y) axis crosses at maximum value, " which also moves the Y axis to the right side, but the axis labels are still on the outside. Try this. With the Y axis selected (click any y axis label), do Format - Axis. In the Patterns tab, there are radio buttons for putting the tick marks and labels on the inside or outside. -- Regards from Virginia Beach, Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Billy L" <Billy wrote in message ... Hi, all, After reversal of x axis, I moved y axis from right to left. However, value of the y axis appears inside of the chart, how can I move them outside. Many thanks. Billy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Line Chart - Switch Axis Position | Charts and Charting in Excel | |||
change the position of X-axis labels | Charts and Charting in Excel | |||
Need PivotChart x axis to cross Y axis at minimum Y axis value | Charts and Charting in Excel | |||
how can i change position of x and y axis in chart? | Charts and Charting in Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel |