+ Reply to Thread
Results 1 to 3 of 3

Pivot Chart Date Axis not scaled with 1 tick mark per day. Madness ensues.

  1. #1
    Registered User
    Join Date
    06-02-2013
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    16

    Question Pivot Chart Date Axis not scaled with 1 tick mark per day. Madness ensues.

    Dear Gurus,

    1. I have a small data table with data against a non continuous range of dates.
    2. A pivot table then summarizes that table.
    3. A pivot chart with dates on x-axis shows only the dates in the pivot, and not a continuous range of dates. So it gives no sense of time scale.


    The other internet answers are not working for me, e.g...
    1. The tick box "show items with no data" in the pivot table's date field settings is not solving it.
    2. In pivot chart axis options I have "Interval between tick marks" set to 1 (and the axis is set to date format) but still no luck.

    So it either isn't possible, or Excel hates me

    My actual spreadsheet is attached. The one I use has a very basic macro in it, so I've also included one without a macro if you prefer (all the macro does is refresh the pivot). But both are there in case you think the macro may be messing with the sheet in some way.

    If you can solve this, you're a total legend

    Thanks
    Bob
    Attached Files Attached Files

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

    Re: Pivot Chart Date Axis not scaled with 1 tick mark per day. Madness ensues.

    See previous thread
    http://www.excelforum.com/excel-char...t-equally.html
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-02-2013
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Pivot Chart Date Axis not scaled with 1 tick mark per day. Madness ensues.

    Thanks Andy - appreciate the link. Shame it can't be done, but a challenge for the future I guess.

+ 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. Secondary Axis tick mark formatting problems
    By jlott42 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-26-2015, 10:40 AM
  2. How to get vertical axis to show a tick mark
    By amartino44 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-05-2013, 08:42 PM
  3. Keep chart data on tick marks when using secondary axis
    By jscott15 in forum Excel General
    Replies: 4
    Last Post: 08-26-2010, 11:09 AM
  4. [SOLVED] How to change tick mark labels in z axis from values to texts?
    By Flroa in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-11-2006, 01:35 PM
  5. [SOLVED] How do I justify/align tick mark labels on a horizontal bar chart?
    By blinko in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-16-2005, 11:10 PM
  6. Can tick mark labels be flipped about axis?
    By olongdomango@hotmail.com in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-20-2005, 12:05 PM
  7. Y-axis tick marks in middle of chart?
    By Ed in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-26-2005, 05:15 PM

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