+ Reply to Thread
Results 1 to 3 of 3

Displaying a timeline on the X Axis

  1. #1
    Registered User
    Join Date
    02-28-2016
    Location
    Sunshine Coast, Queensland
    MS-Off Ver
    365 for Business
    Posts
    23

    Displaying a timeline on the X Axis

    Hi

    Appreciate any insight to the following:

    Please refer to my attached file which has a text box explaining what I would like to visualise on the pivot chart.

    Basically what I want to display is upcoming construction packages that are commencing on a project (Required On Site date (ROS date)) By changing the timeline or by selecting the 'Top 10 upcoming packages", the visual will return the packages that are soon to commence.

    Hope that makes sense.

    (Just think I am getting my pivot fields wrong. i.e. not too sure if it should be in Filters, Columns, Rows or Values. I have correctly formatted the register and returns date values).
    Attached Files Attached Files
    Last edited by bundyanimal; 08-07-2021 at 06:34 AM.

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,055

    Re: Displaying a timeline on the X Axis

    Package Description to Rows, ROS Date to Values and Summarize Values By Max.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-28-2016
    Location
    Sunshine Coast, Queensland
    MS-Off Ver
    365 for Business
    Posts
    23

    Re: Displaying a timeline on the X Axis

    Thanks very much Josephteh.

    I will get in and have a look later, as your way looks a little better at what I ended up doing.

    Thanks.

+ 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. Charting a Timeline with custom Y-Axis
    By TyFrown in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-12-2021, 02:40 PM
  2. Replies: 0
    Last Post: 01-23-2019, 05:25 PM
  3. [SOLVED] Need a Timeline on my X axis for a Gantt chart
    By noboffinme in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-02-2018, 11:24 PM
  4. Replies: 2
    Last Post: 12-16-2015, 06:25 AM
  5. Help with Axis on a Timeline
    By Chris_PLP in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 05-28-2014, 07:20 PM
  6. How do I combine 2 columns (e.g. month and day) into a timeline x-axis
    By dannorthrup in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-09-2012, 12:21 PM
  7. Change x axis scale mid graph on timeline
    By natedawg400 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-22-2011, 08:54 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