+ Reply to Thread
Results 1 to 4 of 4

Place Text box between X axis and bottom border of chart

  1. #1
    Registered User
    Join Date
    08-31-2009
    Location
    Mbabane, Zimbabwe
    MS-Off Ver
    Excel 2010
    Posts
    29

    Place Text box between X axis and bottom border of chart

    In Excel 2010 I need to place a text box between the X axis and the bottom border of a chart.
    How can increase the white space between the X axis and the bottom border to allow me to do this?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,866

    Re: Place Text box between X axis and bottom border of chart

    increase the value of 'Label distance from axis' on the format axis dialog.

    What sort of information should appear between axis labels and edge of plot area?
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-31-2009
    Location
    Mbabane, Zimbabwe
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Place Text box between X axis and bottom border of chart

    I need expand the data table
    The data table shows the values of each series in a stacked bar chart. I need it to include additional data so I want to insert a table.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,866

    Re: Place Text box between X axis and bottom border of chart

    The setting will increase the gap but the axis text will be centered in the space between plotarea and top of table.

    If you do not have table bordering applied you could add some dummy series to the chart to get addition blank rows in the data table.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1