+ Reply to Thread
Results 1 to 3 of 3

Excel 2013 PivotChart Horizontal Axis Formatting

  1. #1
    Registered User
    Join Date
    01-03-2016
    Location
    Sydney and Kuala Lumpur
    MS-Off Ver
    Office 365
    Posts
    5

    Excel 2013 PivotChart Horizontal Axis Formatting

    Vertical Axis.PNG
    Vertical Axis

    I'm having problems in formatting the horizontal x-axis. I cant find my way to set up the max/min boundary, define the major/minor units, for the horizontal axis. Peculiarly, the axis formatting for vertical axis, is easily accessible and works perfectly.

    Any solution to this problem?

    Horizontal Axis.PNG
    Horizontal Axis
    Last edited by healme.crepe; 01-07-2016 at 10:51 AM. Reason: Wrong version.

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Excel 2010 PivotChart Horizontal Axis Formatting

    I do not think that is dialog from 2010.

    I think your axis is text not numeric axis - what kind of data does it use?
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Registered User
    Join Date
    01-03-2016
    Location
    Sydney and Kuala Lumpur
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Excel 2010 PivotChart Horizontal Axis Formatting

    Quote Originally Posted by Izandol View Post
    I do not think that is dialog from 2010.

    I think your axis is text not numeric axis - what kind of data does it use?
    I formatted the horizontal axis parameters from the original tables, as numbers. And sorry as I mistaken it to be Excel 2010, while it is actually Excel 2013.

+ 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. [SOLVED] Excel PivotChart - Fix X-axis range (Excel 2010)
    By Xx7 in forum Excel General
    Replies: 3
    Last Post: 03-19-2014, 03:46 PM
  2. Replies: 1
    Last Post: 11-28-2012, 01:17 PM
  3. Replies: 1
    Last Post: 03-22-2012, 07:54 PM
  4. Formatting grouped horizontal axis of Pivot Chart
    By tunaaa in forum Excel General
    Replies: 9
    Last Post: 09-05-2011, 04:44 AM
  5. Formatting Horizontal Axis Titles
    By lindsayboxer in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 03-30-2011, 05:31 AM
  6. Replies: 2
    Last Post: 03-11-2011, 09:02 AM
  7. Horizontal Axis Differential Formatting
    By BRISBANEBOB in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 03-22-2010, 08:19 PM
  8. How do I Retain the 2nd Y-axis on a PivotChart ?
    By Steve in forum Excel General
    Replies: 0
    Last Post: 10-18-2005, 11:05 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