Y Axis not extending fully or showing labels
Hi, please see the attached chart. I have tried changing, dragging corners, changing the labels distance, etc. but I cannot get the Y axis to fully show the top level. Anything that moves into triple digits or more, does this. Also note, the axis seem "right aligned" to within the chart area. Is there any way to force the to center so that you can extend the right side further and fix the problem? Please advise.
An image attachment has very little value. Just attach the Excel file. It's easier than taking a screenshot first and then attaching that.
Under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
Sorry about that. Please see attached excel doc.
You have to add the horizontal axis,
Chart Tools > Design > Add Chart Element > Axes > Primary Horizontal
then adjust the Min and Max to suit your desired format (or set them both to Auto), then you can delete the axis.
YOU ROCK! Thank you, this has been driving me nuts for the past year!
You are very welcome, and welcome to the Forum!
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks