+ Reply to Thread
Results 1 to 6 of 6

Time series chart with irregular interval

  1. #1
    Registered User
    Join Date
    07-22-2019
    Location
    Rotorua, New Zealand
    MS-Off Ver
    Office365
    Posts
    3

    Time series chart with irregular interval

    Hi,
    I am looking for a line chart with time data between 1740-2019 having data for the years 1740,1810,1830,1851,1901,1996,2019
    I want the years on x-axis and axis label only 1740,1810,1830,1851,1901,1996,2019
    One more thing, distance between 1740-1810 is unit 70 and 1830-1851 is unit 21 so almost 1/3 of the previous one.
    Regards,
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,715

    Re: Time series chart with irregular interval

    One way to do this is what you appear to have attempted – an ordinary line chart with gaps to represent to missing years. The problem with this is that it will force your x axis labels to vertical as it tries to accommodate missing values. It also means a lot of empty space on your worksheet.

    An XY scatter chart will solve this by automatically scaling the gaps between your x values without needing to include gaps, but it will not give the particular years you want as x axis labels.

    The simplest way around this is to leave the x axis labels to scale automatically and add the years as labels to the data points in the graph.

    If you particularly need the years on the x axis, you could try a workaround of creating a dummy series with a value of 0 at each data point and then adding data labels to this series and setting the label text to x values. If you also set this series’ line colour to nothing and the marker style to a cross the same colour as your x-axis line, it will appear like a tick mark label on the x axis.

    Both methods are illustrated in the attached file.

  3. #3
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,715

    Re: Time series chart with irregular interval

    oops - here is the attachment
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    07-22-2019
    Location
    Rotorua, New Zealand
    MS-Off Ver
    Office365
    Posts
    3

    Re: Time series chart with irregular interval

    Thank you very much Nicky.
    It has worked well for me.
    I will try to create dummy series for X axis label.
    It was really great help.
    Regards,
    Kirti

  5. #5
    Registered User
    Join Date
    07-22-2019
    Location
    Rotorua, New Zealand
    MS-Off Ver
    Office365
    Posts
    3

    Re: Time series chart with irregular interval

    Yes, I am able to use dummy series of 0 as tick on x axis.
    It has just solved my problem entirely.
    Thank you very much Nicky.
    Kind regards,
    Kirti

  6. #6
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,715

    Re: Time series chart with irregular interval

    glad i could help

+ 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] showing the 2 chart line with 2 difference time sampling interval in one graph
    By fakhteh in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-10-2016, 07:35 AM
  2. Please help on time interval chart
    By pcmystery in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2015, 11:10 AM
  3. Gantt Chart - Short Time Interval (0.1s) and Colorful Bars needed
    By starryjazz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2014, 09:36 PM
  4. Replies: 0
    Last Post: 04-23-2012, 10:06 AM
  5. Excel 2007 : Choosing cell from irregular interval
    By shinizaki in forum Excel General
    Replies: 2
    Last Post: 10-05-2010, 08:39 AM
  6. Drawing line chart with irregular time periods
    By JustinF in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-10-2008, 04:56 AM
  7. i want to clculate the interval confidence of the 30 time series.
    By ahmedou in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-04-2005, 05:05 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