+ Reply to Thread
Results 1 to 5 of 5

Chart to show year ranges for time line

  1. #1
    Registered User
    Join Date
    02-04-2020
    Location
    Baltimore, MD
    MS-Off Ver
    O365
    Posts
    6

    Chart to show year ranges for time line

    I'm trying to make a historical timeline. Like, so-and-so lived from 220-289, and such-and-such lived from 270-340. Using the standard timeline mechanism doesn't work because a) I don't have actual dates; just years, and b) they're all prior to the 1800s.

    I can't figure out how to do this, but it should be simple. I thought I could use a line graph, but they don't format right.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Chart to show year ranges for time line

    I am having trouble visualizing exactly what you have and exactly what you want. My first guess is that you want some kind of "Gantt" chart. If the built in Gantt chart tool does not know how to work with your "just years" data, then a Gantt chart can easily be created as a stacked bar chart, which should have no trouble with the data you have. Help us understand exactly what you are trying to end up with, and we should be able to help you program that into the spreadsheet.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    02-04-2020
    Location
    Baltimore, MD
    MS-Off Ver
    O365
    Posts
    6

    Re: Chart to show year ranges for time line

    Yeah, a Gantt chart might work. Just not sure how to do one of those in Excel.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Chart to show year ranges for time line

    This shows how to build a basic Gantt chart as a stacked bar chart: https://www.excel-easy.com/examples/gantt-chart.html

  5. #5
    Registered User
    Join Date
    02-04-2020
    Location
    Baltimore, MD
    MS-Off Ver
    O365
    Posts
    6

    Re: Chart to show year ranges for time line

    That helps a lot! 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. Year on Year Line Chart
    By WorkWear in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 04-26-2018, 03:43 PM
  2. Replies: 0
    Last Post: 01-29-2014, 08:10 PM
  3. [SOLVED] Chart Lengend to show marker style on hidden line - Line chart
    By etaf in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-22-2013, 05:19 PM
  4. Replies: 2
    Last Post: 06-15-2012, 03:06 AM
  5. 2010 Line Chart Show Zero Value Line
    By erock24 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-27-2011, 08:54 PM
  6. Charts - Line Chart, How to Show data Ranges?
    By chickencoop in forum Excel General
    Replies: 4
    Last Post: 01-06-2009, 08:43 PM
  7. Show line conditionally - Line Chart
    By idrisb59 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-20-2008, 12:45 PM

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