Timeline chart from text containing cells

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: K. Georgiadis (anonymous_at_discussions.microsoft.com)
Date: 05/25/04 

Date: Tue, 25 May 2004 06:30:56 -0700

I have seen great tips here for creating Excel timeline
charts from numerical data. My question may be far afield
but here it is:

is there a way to create a timeline chart from a table
organized as follows:

1) Years 2004 to 2009 as column headings, columns B-G
2) Product descriptions as row titles in column A
3) keywords (such as "RE", "EX", "FS") in the
intersecting cells

Can Excel convert these key words to distinctive symbols
(such as a square bullet, round bullet, diamond shaped
bullet) and create a timeline chart?

Relevant Pages

  • Re: Removing span of dates
    ... We can request Microsoft to change the laws of Physics, ... In your standard Gantt Chart View, there is a Timeline at the top. ... I want the dates at the top or the chart, to squeeze a date range together, ...
    (microsoft.public.project)
  • Re: Analysing time and days patterns in a chart
    ... This is the starting point of the Excel calendar system. ... Now you can use the full number in a scatter chart to graph your dates and times. ... Sadly, you can't use line charts, even with the "Timeline" axis option, because timelines for some reason only operate as integers, i.e. whole days, no times. ... However, you can very easily format scatter series with lines, so that's not a problem. ...
    (microsoft.public.excel.charting)
  • Re: Timeline chart from text containing cells
    ... copying the timeline matrix (a worksheet, ... like a chart, not truly a chart. ... axis, dates on ... or you can add the label to the points. ...
    (microsoft.public.excel.charting)
  • Gantt Chart
    ... I've worked out a fairly decent Gantt-style chart for use in project ... am having is this project schedule's timeline needs to be based only on ... Axis or Value Axis, to be broken up into units of five and display the ... weekends altogether so the chart bars don't get broken up. ...
    (microsoft.public.excel.charting)
  • Re: Removing span of dates
    ... You could colour the bar white so that it doesn't show - Format/Bar, ... In your standard Gantt Chart View, there is a Timeline at the top. ... "To squeeze a date range together" - If I'm guessing right here, ...
    (microsoft.public.project)