+ Reply to Thread
Results 1 to 2 of 2

Timeline graph for machine status from pivot table

  1. #1
    Registered User
    Join Date
    04-09-2020
    Location
    Lisbon, Portugal
    MS-Off Ver
    Professional Plus 13
    Posts
    1

    Timeline graph for machine status from pivot table

    Hi,

    I need to make a graph that would show the time a machine is running and stopped, like the one below.

    timeline.jpg.jpg

    The data comes from a pivot table with the follwing columns: Start Time (day/hour) | End Time (day/hour) | Status (Running/Stopped)

    Can anyone help? Iīve been trying several graphs but canīt get one like that.

    Thanks in advance and best regards.

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

    Re: Timeline graph for machine status from pivot table

    Hello arguimar and Welcome to Excel Forum.
    This is not to imply that I or anyone here can produce the chart seen in post #1, however we may have a better chance of producing one if we could see a sample of the source data and pivot table.
    Instructions for uploading sample workbooks are given in the banner at the top of the page.
    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. Timeline in Pivot Table problem
    By Eric Tsang in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-21-2019, 04:24 AM
  2. How to link Timeline and Slicers in pivot table
    By Vincent Katta in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-04-2019, 09:37 AM
  3. Pivot table and pivot combo chart with timeline
    By thytonen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-12-2019, 02:23 AM
  4. [SOLVED] VBA: transpose text on current machine status,time changed and with comment
    By Sharonjit in forum Excel Programming / VBA / Macros
    Replies: 59
    Last Post: 12-19-2018, 12:10 PM
  5. Timeline graph / VBA from large data table.
    By Hovi in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-02-2017, 09:51 PM
  6. Pivot Table - Data Agnostic Timeline
    By NapB9 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-21-2013, 03:50 PM
  7. Using Pivot table data outside of an SQL Server machine
    By moty.98 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 06-03-2013, 05:32 AM

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