+ Reply to Thread
Results 1 to 2 of 2

Auto scale X axis

  1. #1
    Registered User
    Join Date
    03-26-2012
    Location
    Rochester Mn.
    MS-Off Ver
    Excel 2007
    Posts
    1

    Auto scale X axis

    I have recently upgrade to office 2010 including excel. I had a worksheet that has data added to it each month and a three element line chart was created. The X axis is the data. The x axis was scaled by the dates. There was an option in earlier version that allows you to ignore cell that were blank. This allow the X axis to auto scale. Is the option available in 2010 and if so where?

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

    Re: Auto scale X axis

    The option for hidden and empty cells is on the Select Data dialog. Same place as xl2007.
    If you upgraded from xl2003 or older this setting used to be on the tools > options > chart dialog.
    Cheers
    Andy
    www.andypope.info

+ 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