Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

This is what the x-axis of my graph currently looks like (Excel 2010):

enter image description here

The dates are in the format YYYY-MM-DD, but as you can see month and date are chopped off. I tried resizing (the dots at the corners look like resizing handles), but it seems you can't do that. Selecting a smaller font also reduces the height.

How can I show the dates completely?

share|improve this question
add comment

1 Answer

No, you can't resize the axes. But you can resize the plot area. Click in the main plot (or select 'Plot Area' from the dropdown in the 'Chart Tools' ribbon tab). You should be able to make it a little smaller to accommodate your axis.

share|improve this answer
    
Better yet, resizing the chart area fixed the axis, thanks! (There are ten settings for silly options like "shadow, glow and soft edges", but none for essentials like resizing. Typically Microsoft, shall we say? Also, why show resizing handles that don't work?) –  stevenvh Mar 27 '13 at 13:45
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.