Prev: How do you get the templete to print in it's total graph?
Next: Process control chart for quality control in exel?
From: hans L on 10 May 2010 08:32
I have developed a Gantt chart that shows dates as tick marks along the
X-axis. These dates con be converted to a general number format but I want
to manipulate these numbers so that the tick marks represent the durations
between the dates. If, for instance, my first three tick marks read
4/1/2010, 5/1/2010 and 5/31/2010, I want to see the values 0, 30, 60 etc. to
indicate the increments between the tick marks. Thank you for your help.
From: "David Biddulph" groups [at] on 10 May 2010 17:27
Sort it out on your data sheet, not on your chart sheet. If you want to
plot not as date but as number of days, produce a column which has number of
days (by subtracting 4/1/2010 from each of your dates), and use that as your
X-axis series.
--
David Biddulph


"hans L" <hansL(a)discussions.microsft.com> wrote in message
news:C401F854-8141-4A08-8873-608F8376B226(a)microsoft.com...
> I have developed a Gantt chart that shows dates as tick marks along the
> X-axis. These dates con be converted to a general number format but I
> want
> to manipulate these numbers so that the tick marks represent the durations
> between the dates. If, for instance, my first three tick marks read
> 4/1/2010, 5/1/2010 and 5/31/2010, I want to see the values 0, 30, 60 etc.
> to
> indicate the increments between the tick marks. Thank you for your help.


From: hans L on 11 May 2010 08:40
Unfortunately, it's not that simple. My data looks like this:
Task Start Duration Finish
A 4/12/10 60 6/11/10
B 5/3/10 85 7/12/10
C 6/14/10 63 8/16/10
By defining he X-axis as starting on 4/1/10 and ending at, say, 7/5/10 and
defining tick marks at every 30 days, the chart generates the dates 4/1/2010,
5/1/10, 5/31/10 and 6/30/10, etc. So, it's the tick marks that I want to
convert from a date format to read 0, 30, 60 and 90, etc. This way the chart
would become a generic chart independent of start and finish dates.
Thanks
"David Biddulph" wrote:

> Sort it out on your data sheet, not on your chart sheet. If you want to
> plot not as date but as number of days, produce a column which has number of
> days (by subtracting 4/1/2010 from each of your dates), and use that as your
> X-axis series.
> --
> David Biddulph
>
>
> "hans L" <hansL(a)discussions.microsft.com> wrote in message
> news:C401F854-8141-4A08-8873-608F8376B226(a)microsoft.com...
> > I have developed a Gantt chart that shows dates as tick marks along the
> > X-axis. These dates con be converted to a general number format but I
> > want
> > to manipulate these numbers so that the tick marks represent the durations
> > between the dates. If, for instance, my first three tick marks read
> > 4/1/2010, 5/1/2010 and 5/31/2010, I want to see the values 0, 30, 60 etc.
> > to
> > indicate the increments between the tick marks. Thank you for your help.
>
>
> .
>
From: Jon Peltier on 11 May 2010 12:43
It is that simple. In the worksheet, subtract 4/12/10 from all dates, so
the start values for the three tasks are 0, 21, and 63.

I think this is what David has suggested.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 5/11/2010 8:40 AM, hans L wrote:
> Unfortunately, it's not that simple. My data looks like this:
> Task Start Duration Finish
> A 4/12/10 60 6/11/10
> B 5/3/10 85 7/12/10
> C 6/14/10 63 8/16/10
> By defining he X-axis as starting on 4/1/10 and ending at, say, 7/5/10 and
> defining tick marks at every 30 days, the chart generates the dates 4/1/2010,
> 5/1/10, 5/31/10 and 6/30/10, etc. So, it's the tick marks that I want to
> convert from a date format to read 0, 30, 60 and 90, etc. This way the chart
> would become a generic chart independent of start and finish dates.
> Thanks
> "David Biddulph" wrote:
>
>> Sort it out on your data sheet, not on your chart sheet. If you want to
>> plot not as date but as number of days, produce a column which has number of
>> days (by subtracting 4/1/2010 from each of your dates), and use that as your
>> X-axis series.
>> --
>> David Biddulph
>>
>>
>> "hans L"<hansL(a)discussions.microsft.com> wrote in message
>> news:C401F854-8141-4A08-8873-608F8376B226(a)microsoft.com...
>>> I have developed a Gantt chart that shows dates as tick marks along the
>>> X-axis. These dates con be converted to a general number format but I
>>> want
>>> to manipulate these numbers so that the tick marks represent the durations
>>> between the dates. If, for instance, my first three tick marks read
>>> 4/1/2010, 5/1/2010 and 5/31/2010, I want to see the values 0, 30, 60 etc.
>>> to
>>> indicate the increments between the tick marks. Thank you for your help.
>>
>>
>> .
>>
From: hans L on 11 May 2010 20:14
I'm afraid I didn't make myself clear. I do not want to convert the dates of
the table as numbers but the tick marks in the graph so they appear as 30 day
increments or 25, or 20 as I choose. I used an example of a Gannt chart that
came from your blog. Ideally, the tick marks would show as vertical lines
so that the reader of the graph gets a good sense of the duration of the
tasks, not when they take place. I extract the data from other software and
that helps me to create the graph.
"Jon Peltier" wrote:

> It is that simple. In the worksheet, subtract 4/12/10 from all dates, so
> the start values for the three tasks are 0, 21, and 63.
>
> I think this is what David has suggested.
>
> - Jon
> -------
> Jon Peltier
> Peltier Technical Services, Inc.
> http://peltiertech.com/
>
>
> On 5/11/2010 8:40 AM, hans L wrote:
> > Unfortunately, it's not that simple. My data looks like this:
> > Task Start Duration Finish
> > A 4/12/10 60 6/11/10
> > B 5/3/10 85 7/12/10
> > C 6/14/10 63 8/16/10
> > By defining he X-axis as starting on 4/1/10 and ending at, say, 7/5/10 and
> > defining tick marks at every 30 days, the chart generates the dates 4/1/2010,
> > 5/1/10, 5/31/10 and 6/30/10, etc. So, it's the tick marks that I want to
> > convert from a date format to read 0, 30, 60 and 90, etc. This way the chart
> > would become a generic chart independent of start and finish dates.
> > Thanks
> > "David Biddulph" wrote:
> >
> >> Sort it out on your data sheet, not on your chart sheet. If you want to
> >> plot not as date but as number of days, produce a column which has number of
> >> days (by subtracting 4/1/2010 from each of your dates), and use that as your
> >> X-axis series.
> >> --
> >> David Biddulph
> >>
> >>
> >> "hans L"<hansL(a)discussions.microsft.com> wrote in message
> >> news:C401F854-8141-4A08-8873-608F8376B226(a)microsoft.com...
> >>> I have developed a Gantt chart that shows dates as tick marks along the
> >>> X-axis. These dates con be converted to a general number format but I
> >>> want
> >>> to manipulate these numbers so that the tick marks represent the durations
> >>> between the dates. If, for instance, my first three tick marks read
> >>> 4/1/2010, 5/1/2010 and 5/31/2010, I want to see the values 0, 30, 60 etc.
> >>> to
> >>> indicate the increments between the tick marks. Thank you for your help.
> >>
> >>
> >> .
> >>
> .
>
 |  Next  |  Last
Pages: 1 2 3
Prev: How do you get the templete to print in it's total graph?
Next: Process control chart for quality control in exel?