Prev: How do you get the templete to print in it's total graph?
Next: Process control chart for quality control in exel?
From: "David Biddulph" groups [at] on 11 May 2010 21:38
Too right you didn't make yourself clear!
What you said in your OP was "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. "

If that isn't what you want, perhaps you can now tell us what you *do* want?
--
David Biddulph


"hans L" <hansL(a)discussions.microsft.com> wrote in message
news:9D9454A4-CB69-4405-8C73-E2F67C779B82(a)microsoft.com...
> 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.
>> >>
>> >>
>> >> .
>> >>
>> .
>>

From: Jon Peltier on 12 May 2010 09:53
Can't you set a major tick spacing of 30 days (or whatever you want)?

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


On 5/11/2010 8:14 PM, hans L wrote:
> 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.
>>>>
>>>>
>>>> .
>>>>
>> .
>>
From: hans L on 14 May 2010 13:34
I did set the spacing at 30 days. If I set the format at "General Number" it
reads 40269, 40299 etc. So, how do you set a custom format that subtracts a
certain number of days from what is displayed?

"Jon Peltier" wrote:

> Can't you set a major tick spacing of 30 days (or whatever you want)?
>
> - Jon
> -------
> Jon Peltier
> Peltier Technical Services, Inc.
> http://peltiertech.com/
>
>
> On 5/11/2010 8:14 PM, hans L wrote:
> > 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.
> >>>>
> >>>>
> >>>> .
> >>>>
> >> .
> >>
> .
>
From: "David Biddulph" groups [at] on 14 May 2010 13:39
You DON'T do that with formatting. You do that on the data sheet as we told
you earlier. If you are struggling to understand what you are being told in
English, it may be better if you ask in a newsgroup in your own language.
--
David Biddulph


"hans L" <hansL(a)discussions.microsft.com> wrote in message
news:7058E502-37A9-4429-B368-D7DB32B67DD5(a)microsoft.com...
> I did set the spacing at 30 days. If I set the format at "General Number"
> it
> reads 40269, 40299 etc. So, how do you set a custom format that
> subtracts a
> certain number of days from what is displayed?
>
> "Jon Peltier" wrote:
>
>> Can't you set a major tick spacing of 30 days (or whatever you want)?
>>
>> - Jon
>> -------
>> Jon Peltier
>> Peltier Technical Services, Inc.
>> http://peltiertech.com/
>>
>>
>> On 5/11/2010 8:14 PM, hans L wrote:
>> > 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.
>> >>>>
>> >>>>
>> >>>> .
>> >>>>
>> >> .
>> >>
>> .
>>

From: hans L on 15 May 2010 07:46
You offered a solution in your first e-mail. This forum sometimes comes up
with more than one solution. You didn't specifically say that it could not
be done through formatting. Your reference to my command of the English
language, or implied lack thereof, was uncalled for.
"David Biddulph" wrote:

> You DON'T do that with formatting. You do that on the data sheet as we told
> you earlier. If you are struggling to understand what you are being told in
> English, it may be better if you ask in a newsgroup in your own language.
> --
> David Biddulph
>
>
> "hans L" <hansL(a)discussions.microsft.com> wrote in message
> news:7058E502-37A9-4429-B368-D7DB32B67DD5(a)microsoft.com...
> > I did set the spacing at 30 days. If I set the format at "General Number"
> > it
> > reads 40269, 40299 etc. So, how do you set a custom format that
> > subtracts a
> > certain number of days from what is displayed?
> >
> > "Jon Peltier" wrote:
> >
> >> Can't you set a major tick spacing of 30 days (or whatever you want)?
> >>
> >> - Jon
> >> -------
> >> Jon Peltier
> >> Peltier Technical Services, Inc.
> >> http://peltiertech.com/
> >>
> >>
> >> On 5/11/2010 8:14 PM, hans L wrote:
> >> > 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.
> >> >>>>
> >> >>>>
> >> >>>> .
> >> >>>>
> >> >> .
> >> >>
> >> .
> >>
>
> .
>
First  |  Prev  |  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?