+ Reply to Thread
Results 1 to 2 of 2

Pivot Chart Axis not Formatting Properly

  1. #1
    Registered User
    Join Date
    12-17-2013
    Location
    Kansas City, Kansas
    MS-Off Ver
    Excel 2013
    Posts
    1

    Question Pivot Chart Axis not Formatting Properly

    First, let me apologize if this is an all too simplistic issue but it's driving me nuts!
    I have a pivot table and chart see below:
    PivotChartAxisFormat.JPG

    I am trying to get the X-axis to format in the same fashion as the data MMM-YY.
    I've tried changing the axis to TEXT and no go.

    The data are DATES and I'm just trying to modify the format in the X-axis...

    Any ideas? Thanks in advance!!!
    Last edited by joebark; 04-11-2018 at 02:05 PM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: Pivot Chart Axis not Formatting Properly

    Hello joebark and Welcome to Excel Forum.
    I am copying this reply by RoryA, to a similar question (format to mmm-yy on chart) on a different site: "If you format the dates in the pivot table by altering the Field Settings for the date field, then the chart should reflect that. (if you did it using the Format Cells dialog, then the chart will not match)"
    If this doesn't help then I would suggest uploading a sample of the workbook from which the screen shot is taken.
    To upload a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. negative y axis on pivot chart but axis doesn't change
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 06-24-2015, 02:19 PM
  2. Replies: 1
    Last Post: 05-05-2013, 10:38 PM
  3. Formatting grouped horizontal axis of Pivot Chart
    By tunaaa in forum Excel General
    Replies: 9
    Last Post: 09-05-2011, 04:44 AM
  4. Chart axis not autoscaling properly
    By ChemistB in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-02-2010, 11:47 AM
  5. Chart axis labels not updating properly with VBA
    By d3hartm2 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-05-2009, 12:10 PM
  6. Replies: 0
    Last Post: 07-13-2005, 05:05 PM
  7. [SOLVED] Pivot Chart - Formatting Axis on Data Table
    By Max in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-19-2005, 09:06 AM

Tags for this Thread

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