+ Reply to Thread
Results 1 to 3 of 3

Length's graph issues

  1. #1
    Registered User
    Join Date
    10-20-2020
    Location
    Paris, France
    MS-Off Ver
    Office 2016
    Posts
    2

    Length's graph issues

    Hello,

    I am facing some issues with a graph I would like to create. It is shows on time (length) datas.

    My spreadsheet (I am joining to my post) summarizes the delays observed in my transport activity, ordered by reasons and plants.
    So each value of my table sums up the delay occured in a plant regarding the reason.
    (ex : 01:33:00 delay had occured to plant A due to storms, so far in 2020).

    When I insert a bar graph on it, for some reason I don't get, the y axis, representing length, start to 00:00:000 and then goes to 12:00:00 and restart from 00:00:00 to finish to 12:00:00; and again and again....

    Please, someone could help me ? I would like to fix this issue with the y axis so it adapts properly to my datas : from 00:00:00 to 24:00:00 hours delay for example.

    Thank you
    Malik
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-20-2020
    Location
    Germany
    MS-Off Ver
    Office365
    Posts
    6

    Re: Length's graph issues

    I am using Office 365 so my solution migt not woork for you. Please check.

    1. Right click on your Y-Axis and click format axis.
    2. Go to "Number"
    3. Change type to reflect more then 24 hours.

    Axis time.JPG

  3. #3
    Registered User
    Join Date
    10-20-2020
    Location
    Paris, France
    MS-Off Ver
    Office 2016
    Posts
    2

    Post Re: Length's graph issues

    It does work !!!
    Thank you very much ! I spent ages trying to resolve it by myself

+ 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] How to specify length of bar graph?
    By kjetill in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 03-07-2017, 02:04 PM
  2. [SOLVED] Creating a Graph from a table of indeterminate length
    By locopete999 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-05-2016, 08:48 AM
  3. Automatically detecting data length for graph
    By willist in forum Excel General
    Replies: 2
    Last Post: 07-19-2012, 02:35 PM
  4. Changing graph-series length on many charts
    By Leia in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-12-2011, 08:20 AM
  5. Measuring length of x-axis in a graph
    By Yohans in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-01-2010, 01:12 AM
  6. Field Length Issues,
    By teshiburu1988 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-12-2009, 01:49 PM
  7. Graph with variable data length
    By snoach in forum Excel General
    Replies: 1
    Last Post: 05-27-2005, 05:15 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