+ Reply to Thread
Results 1 to 2 of 2

Timeline of pivot table shows the year 2023 where there is no data from 2023 year

  1. 02-03-2023, 01:14 PM #1
    Gerti Ballia
    Gerti Ballia is offline
    Registered User
    Join Date
    12-07-2016
    Location
    ALBANIA
    MS-Off Ver
    MICROSOFT OFFICE 2013
    Posts
    6

    Timeline of pivot table shows the year 2023 where there is no data from 2023 year

    Hello all,

    I am using a timeline in a pivot table and it is showing filter for the 2023 year. However the data source of my pivot includes data only from 202. If I select the 2023 any month in the timeline, it will not show any value. But just to remove this as do not want in the timeline.Thank you!
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 02-03-2023, 04:54 PM #2
    tanasedn
    tanasedn is offline
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Timeline of pivot table shows the year 2023 where there is no data from 2023 year

    Hi
    this happens when you have December 31, 2022 in your date list. If you remove 31 dec you'll see, after refresh the timeline without 2023.
    I really don't have an explanation of this
    Diana Tanase

    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Call in the Cavalry 2023
    By Glenn Kennedy in forum The Water Cooler
    Replies: 81
    Last Post: 01-13-2024, 12:55 AM
  2. Run-Time Error 2023
    By SKINRIP in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-23-2022, 09:52 AM
  3. [SOLVED] Can't Scroll to Year 2023
    By BobBrown60 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 05-28-2021, 03:23 PM
  4. [SOLVED] Error 2023: How to identify cell in For Each Loop?
    By VAer in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-12-2018, 12:21 AM
  5. [SOLVED] Tediously adding data to a table year-over-year, looking for pivot ideas..
    By 360 in forum Excel Charting & Pivots
    Replies: 24
    Last Post: 03-19-2017, 08:59 AM
  6. Starting with 10 page, 10 year timeline: Want to add scheduled costs and maint. in year 3
    By 6DollarRooster in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-10-2016, 04:07 PM
  7. Excel 2007 : Pivot Table - year on year growth rate for monthly data
    By ktpicho89 in forum Excel General
    Replies: 1
    Last Post: 08-18-2010, 02:43 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1