Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Y-axis tick marks in middle of chart?
I am trying to clean up some charts made my someone else. These are line
charts with 9 data lines. Some of the lines wanted to go above the maximum Y-axis value. When I increased the value to Automatic, the lines are now within the chart. But the Y-axis tickmarks, which were at the top of the chart, are now in the middle of the chart. Actually, they are at the value they were at before; it's as though I've added chart on top of the tick marks and the tick marks didn't move. The values are still above the top edge of the chart where they're supposed to be. Can someone tell me what I need to change to get the tick marks at the top edge of the Y-axis? Thank you. Ed |
#2
|
|||
|
|||
Select the axis double click on it select paterns and select low (or high)
for the location of the tick marks "Ed" wrote: I am trying to clean up some charts made my someone else. These are line charts with 9 data lines. Some of the lines wanted to go above the maximum Y-axis value. When I increased the value to Automatic, the lines are now within the chart. But the Y-axis tickmarks, which were at the top of the chart, are now in the middle of the chart. Actually, they are at the value they were at before; it's as though I've added chart on top of the tick marks and the tick marks didn't move. The values are still above the top edge of the chart where they're supposed to be. Can someone tell me what I need to change to get the tick marks at the top edge of the Y-axis? Thank you. Ed |
#3
|
|||
|
|||
My apologies. I guess I was using the wrong words to describe the problem.
It seems to be the Y-axis (Category axis) itself that's in the middle of the chart (plot area). The tick mark labels are on top of the plot area, aligned 90 degrees like I want. But the Y-axis with the major and minor hash marks needs to sit on the top line of the plot area, and I can't get it there. Ed "bj" wrote in message ... Select the axis double click on it select paterns and select low (or high) for the location of the tick marks "Ed" wrote: I am trying to clean up some charts made my someone else. These are line charts with 9 data lines. Some of the lines wanted to go above the maximum Y-axis value. When I increased the value to Automatic, the lines are now within the chart. But the Y-axis tickmarks, which were at the top of the chart, are now in the middle of the chart. Actually, they are at the value they were at before; it's as though I've added chart on top of the tick marks and the tick marks didn't move. The values are still above the top edge of the chart where they're supposed to be. Can someone tell me what I need to change to get the tick marks at the top edge of the Y-axis? Thank you. Ed |
#4
|
|||
|
|||
Aha - I found it! It's on the X-axis formatting that I set where it meets
the Y-axis. Got it now. Thanks for the boost. Ed "Ed" wrote in message ... My apologies. I guess I was using the wrong words to describe the problem. It seems to be the Y-axis (Category axis) itself that's in the middle of the chart (plot area). The tick mark labels are on top of the plot area, aligned 90 degrees like I want. But the Y-axis with the major and minor hash marks needs to sit on the top line of the plot area, and I can't get it there. Ed "bj" wrote in message ... Select the axis double click on it select paterns and select low (or high) for the location of the tick marks "Ed" wrote: I am trying to clean up some charts made my someone else. These are line charts with 9 data lines. Some of the lines wanted to go above the maximum Y-axis value. When I increased the value to Automatic, the lines are now within the chart. But the Y-axis tickmarks, which were at the top of the chart, are now in the middle of the chart. Actually, they are at the value they were at before; it's as though I've added chart on top of the tick marks and the tick marks didn't move. The values are still above the top edge of the chart where they're supposed to be. Can someone tell me what I need to change to get the tick marks at the top edge of the Y-axis? Thank you. Ed |
#5
|
|||
|
|||
we may be having some discontinuities as to which is the X axis and which is
th Y axis, so try the other axis if it doesn't work select the vertical axis double click on it and select scale one of the lines should read "Catagory X axis crosses at " Set this cell equal to the max value above. "Ed" wrote: My apologies. I guess I was using the wrong words to describe the problem. It seems to be the Y-axis (Category axis) itself that's in the middle of the chart (plot area). The tick mark labels are on top of the plot area, aligned 90 degrees like I want. But the Y-axis with the major and minor hash marks needs to sit on the top line of the plot area, and I can't get it there. Ed "bj" wrote in message ... Select the axis double click on it select paterns and select low (or high) for the location of the tick marks "Ed" wrote: I am trying to clean up some charts made my someone else. These are line charts with 9 data lines. Some of the lines wanted to go above the maximum Y-axis value. When I increased the value to Automatic, the lines are now within the chart. But the Y-axis tickmarks, which were at the top of the chart, are now in the middle of the chart. Actually, they are at the value they were at before; it's as though I've added chart on top of the tick marks and the tick marks didn't move. The values are still above the top edge of the chart where they're supposed to be. Can someone tell me what I need to change to get the tick marks at the top edge of the Y-axis? Thank you. Ed |
#6
|
|||
|
|||
Thanks, bj. It's been a long time since I worked with graphs and charts,
and did indeed have the X and Y mixed up. Thanks for staying with me. Ed "bj" wrote in message ... we may be having some discontinuities as to which is the X axis and which is th Y axis, so try the other axis if it doesn't work select the vertical axis double click on it and select scale one of the lines should read "Catagory X axis crosses at " Set this cell equal to the max value above. "Ed" wrote: My apologies. I guess I was using the wrong words to describe the problem. It seems to be the Y-axis (Category axis) itself that's in the middle of the chart (plot area). The tick mark labels are on top of the plot area, aligned 90 degrees like I want. But the Y-axis with the major and minor hash marks needs to sit on the top line of the plot area, and I can't get it there. Ed "bj" wrote in message ... Select the axis double click on it select paterns and select low (or high) for the location of the tick marks "Ed" wrote: I am trying to clean up some charts made my someone else. These are line charts with 9 data lines. Some of the lines wanted to go above the maximum Y-axis value. When I increased the value to Automatic, the lines are now within the chart. But the Y-axis tickmarks, which were at the top of the chart, are now in the middle of the chart. Actually, they are at the value they were at before; it's as though I've added chart on top of the tick marks and the tick marks didn't move. The values are still above the top edge of the chart where they're supposed to be. Can someone tell me what I need to change to get the tick marks at the top edge of the Y-axis? Thank you. Ed |
#7
|
|||
|
|||
Glad to be of help
"Ed" wrote: Thanks, bj. It's been a long time since I worked with graphs and charts, and did indeed have the X and Y mixed up. Thanks for staying with me. Ed "bj" wrote in message ... we may be having some discontinuities as to which is the X axis and which is th Y axis, so try the other axis if it doesn't work select the vertical axis double click on it and select scale one of the lines should read "Catagory X axis crosses at " Set this cell equal to the max value above. "Ed" wrote: My apologies. I guess I was using the wrong words to describe the problem. It seems to be the Y-axis (Category axis) itself that's in the middle of the chart (plot area). The tick mark labels are on top of the plot area, aligned 90 degrees like I want. But the Y-axis with the major and minor hash marks needs to sit on the top line of the plot area, and I can't get it there. Ed "bj" wrote in message ... Select the axis double click on it select paterns and select low (or high) for the location of the tick marks "Ed" wrote: I am trying to clean up some charts made my someone else. These are line charts with 9 data lines. Some of the lines wanted to go above the maximum Y-axis value. When I increased the value to Automatic, the lines are now within the chart. But the Y-axis tickmarks, which were at the top of the chart, are now in the middle of the chart. Actually, they are at the value they were at before; it's as though I've added chart on top of the tick marks and the tick marks didn't move. The values are still above the top edge of the chart where they're supposed to be. Can someone tell me what I need to change to get the tick marks at the top edge of the Y-axis? Thank you. Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel | |||
Scatter chart x axis tick mark lables | Charts and Charting in Excel |