+ Reply to Thread
Results 1 to 4 of 4

Excel PivotChart - Fix X-axis range (Excel 2010)

  1. #1
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Excel PivotChart - Fix X-axis range (Excel 2010)

    I am trying to change the X-axis date range to Feb 1/14 - Mar 20/14.

    I have data from Jan 1/14 - Mar 24/14. How can I do this in VBA or Excel 2010.
    Attached Files Attached Files
    Last edited by Xx7; 03-19-2014 at 07:09 PM.

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Excel PivotChart - Fix X-axis range (Excel 2010)

    In your Pivot Graph, there is a Date filter in the lower left corner. Click on that and click on Date Filters. Click on Between and use the calendars provided to select the first and last dates. Your chart will update to show only that data.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Re: Excel PivotChart - Fix X-axis range (Excel 2010)

    Perfect, thanks alot newdoverman!

    I've included a button to update this.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Excel PivotChart - Fix X-axis range (Excel 2010)

    Thanks for the feedback. The addition of a button seems like a good idea to me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How can I add tertiary Y axis in my excel 2010
    By vmusa001 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-19-2013, 09:10 PM
  2. Excel 2010 not displaying all X-axis labels
    By jo_b in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 06-21-2013, 09:23 AM
  3. Is there a way to have a smart axis using Excel 2010?
    By emusinger in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-08-2013, 06:19 PM
  4. [SOLVED] Alignment of Secondary X-Axis in Excel 2010
    By Krandamor in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-16-2013, 02:49 PM
  5. Excel 2010 - Incorrect Axis on Graph
    By Todd_Woods in forum Excel General
    Replies: 2
    Last Post: 04-16-2012, 10:06 AM

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