• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Display X-Axis at bottom of Chart Area

W

wsnyder

New Member
Hi all,


Using Excel 2007

I charted some values that are a mix of positive and negatives over a span of six years

The X-Axis seeme to be displayed in about the middle of the chart with a label ever third tick mark (04, 07, 10 for years)


I would prefer to display the X-Axis at the bottom of the chart area

I have tried several option but cannot seem to make it happen

-Overlaid a second chart with all items transparent except X-Axis labels.

-Added second series to the original chart


Any other ideas?

Thanks

Winston
 
Winston

Right click the vertical axis

Format Axis

Right Axis crosses at

Set to Axis Value and type in the Minimum value
 
Thanks Hui


I ended up having to enter the min manually to force the X Axis to the bottom of the chart area


Is there an option in Excel 2007 so that I can still auto scale yet force the X Axis to the bottom of the chart area? VBA Option perhaps?


Thanks

Winston
 
You must log in or register to reply here.
Back
Top