I am able to add a graph that produces a chart for me on a report with no
problem.

The type of graph I am using is line a multiple layer (with each layer)
indicating a project manpower requirement. The vertical axis if the total
manpower. I like to add a horizontal line (i.e. 24 man level) across the
grahic to show the maximum manpower available.

How can I do this. I have seen vba code adding Trendlines to the graph
object.

Thanks,

Gary

You might be able to add another column to your Row Source like:
Field: Man Level: 24


--
Duane Hookom
MS Access MVP

"Gary" <(E-Mail Removed)> wrote in message
news:E3A97ED3-7A64-4C66-A399-(E-Mail Removed)...
>I am able to add a graph that produces a chart for me on a report with no
> problem.
>
> The type of graph I am using is line a multiple layer (with each layer)
> indicating a project manpower requirement. The vertical axis if the total
> manpower. I like to add a horizontal line (i.e. 24 man level) across the
> grahic to show the maximum manpower available.
>
> How can I do this. I have seen vba code adding Trendlines to the graph
> object.
>
> Thanks,
>
> Gary

Any suggestions on adding that extra column to my Rowsource??

This is my RowSource:
TRANSFORM Sum([Heads]) AS [SumOfHeads] SELECT [Period] FROM [Rept#001_Table]
GROUP BY [Period] PIVOT [Program];

Thank You,

Gary


"Duane Hookom" wrote:

> You might be able to add another column to your Row Source like:
> Field: Man Level: 24
>
>
> --
> Duane Hookom
> MS Access MVP
>
> "Gary" <(E-Mail Removed)> wrote in message
> news:E3A97ED3-7A64-4C66-A399-(E-Mail Removed)...
> >I am able to add a graph that produces a chart for me on a report with no
> > problem.
> >
> > The type of graph I am using is line a multiple layer (with each layer)
> > indicating a project manpower requirement. The vertical axis if the total
> > manpower. I like to add a horizontal line (i.e. 24 man level) across the
> > grahic to show the maximum manpower available.
> >
> > How can I do this. I have seen vba code adding Trendlines to the graph
> > object.
> >
> > Thanks,
> >
> > Gary
>
>
>

TRANSFORM Sum([Heads]) AS [SumOfHeads]
SELECT [Period] , 24 As [Man level]
FROM [Rept#001_Table]
GROUP BY [Period], 24
PIVOT [Program];

--
Duane Hookom
MS Access MVP


"Gary" <(E-Mail Removed)> wrote in message
news:A38173C2-102E-492E-A50E-(E-Mail Removed)...
> Any suggestions on adding that extra column to my Rowsource??
>
> This is my RowSource:
> TRANSFORM Sum([Heads]) AS [SumOfHeads] SELECT [Period] FROM
> [Rept#001_Table]
> GROUP BY [Period] PIVOT [Program];
>
> Thank You,
>
> Gary
>
>
> "Duane Hookom" wrote:
>
>> You might be able to add another column to your Row Source like:
>> Field: Man Level: 24
>>
>>
>> --
>> Duane Hookom
>> MS Access MVP
>>
>> "Gary" <(E-Mail Removed)> wrote in message
>> news:E3A97ED3-7A64-4C66-A399-(E-Mail Removed)...
>> >I am able to add a graph that produces a chart for me on a report with
>> >no
>> > problem.
>> >
>> > The type of graph I am using is line a multiple layer (with each layer)
>> > indicating a project manpower requirement. The vertical axis if the
>> > total
>> > manpower. I like to add a horizontal line (i.e. 24 man level) across
>> > the
>> > grahic to show the maximum manpower available.
>> >
>> > How can I do this. I have seen vba code adding Trendlines to the
>> > graph
>> > object.
>> >
>> > Thanks,
>> >
>> > Gary
>>
>>
>>

I didn't get it to work:

This is my RowSource:

TRANSFORM Sum([Heads]) AS [SumOfHeads] SELECT [Period], 24 As [Roster] FROM
[Rept#001_Table] GROUP BY [Period], 24 PIVOT [Program];


This is what I have for the Rept#001_Table:

Program Heads Period Roster
BEM CRAD (near 1 6/13/2006 24
BEM CRAD (near 1 7/13/2006 24
BEM CRAD (near 1 8/13/2006 24
BEM CRAD (near 0.5 9/13/2006 24


Any suggestions???


Thanks,

Gary

"Duane Hookom" wrote:

> TRANSFORM Sum([Heads]) AS [SumOfHeads]
> SELECT [Period] , 24 As [Man level]
> FROM [Rept#001_Table]
> GROUP BY [Period], 24
> PIVOT [Program];
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "Gary" <(E-Mail Removed)> wrote in message
> news:A38173C2-102E-492E-A50E-(E-Mail Removed)...
> > Any suggestions on adding that extra column to my Rowsource??
> >
> > This is my RowSource:
> > TRANSFORM Sum([Heads]) AS [SumOfHeads] SELECT [Period] FROM
> > [Rept#001_Table]
> > GROUP BY [Period] PIVOT [Program];
> >
> > Thank You,
> >
> > Gary
> >
> >
> > "Duane Hookom" wrote:
> >
> >> You might be able to add another column to your Row Source like:
> >> Field: Man Level: 24
> >>
> >>
> >> --
> >> Duane Hookom
> >> MS Access MVP
> >>
> >> "Gary" <(E-Mail Removed)> wrote in message
> >> news:E3A97ED3-7A64-4C66-A399-(E-Mail Removed)...
> >> >I am able to add a graph that produces a chart for me on a report with
> >> >no
> >> > problem.
> >> >
> >> > The type of graph I am using is line a multiple layer (with each layer)
> >> > indicating a project manpower requirement. The vertical axis if the
> >> > total
> >> > manpower. I like to add a horizontal line (i.e. 24 man level) across
> >> > the
> >> > grahic to show the maximum manpower available.
> >> >
> >> > How can I do this. I have seen vba code adding Trendlines to the
> >> > graph
> >> > object.
> >> >
> >> > Thanks,
> >> >
> >> > Gary
> >>
> >>
> >>
>
>
>

I just noticed that it added 24 man level to graph which increased my over
all man level by 24. Not quite what I needed. I needed a line going across
at the 24 man level without increasing the over man level.


Thanks,

Gary



"Duane Hookom" wrote:

> TRANSFORM Sum([Heads]) AS [SumOfHeads]
> SELECT [Period] , 24 As [Man level]
> FROM [Rept#001_Table]
> GROUP BY [Period], 24
> PIVOT [Program];
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "Gary" <(E-Mail Removed)> wrote in message
> news:A38173C2-102E-492E-A50E-(E-Mail Removed)...
> > Any suggestions on adding that extra column to my Rowsource??
> >
> > This is my RowSource:
> > TRANSFORM Sum([Heads]) AS [SumOfHeads] SELECT [Period] FROM
> > [Rept#001_Table]
> > GROUP BY [Period] PIVOT [Program];
> >
> > Thank You,
> >
> > Gary
> >
> >
> > "Duane Hookom" wrote:
> >
> >> You might be able to add another column to your Row Source like:
> >> Field: Man Level: 24
> >>
> >>
> >> --
> >> Duane Hookom
> >> MS Access MVP
> >>
> >> "Gary" <(E-Mail Removed)> wrote in message
> >> news:E3A97ED3-7A64-4C66-A399-(E-Mail Removed)...
> >> >I am able to add a graph that produces a chart for me on a report with
> >> >no
> >> > problem.
> >> >
> >> > The type of graph I am using is line a multiple layer (with each layer)
> >> > indicating a project manpower requirement. The vertical axis if the
> >> > total
> >> > manpower. I like to add a horizontal line (i.e. 24 man level) across
> >> > the
> >> > grahic to show the maximum manpower available.
> >> >
> >> > How can I do this. I have seen vba code adding Trendlines to the
> >> > graph
> >> > object.
> >> >
> >> > Thanks,
> >> >
> >> > Gary
> >>
> >>
> >>
>
>
>

I really don't know what your data looks like. The query I suggested should
have created a new column in your query (did it?) that could be graphed.

--
Duane Hookom
MS Access MVP

"Gary" <(E-Mail Removed)> wrote in message
news:CB7B32CD-52B8-4947-8982-(E-Mail Removed)...
>I just noticed that it added 24 man level to graph which increased my over
> all man level by 24. Not quite what I needed. I needed a line going
> across
> at the 24 man level without increasing the over man level.
>
>
> Thanks,
>
> Gary
>
>
>
> "Duane Hookom" wrote:
>
>> TRANSFORM Sum([Heads]) AS [SumOfHeads]
>> SELECT [Period] , 24 As [Man level]
>> FROM [Rept#001_Table]
>> GROUP BY [Period], 24
>> PIVOT [Program];
>>
>> --
>> Duane Hookom
>> MS Access MVP
>>
>>
>> "Gary" <(E-Mail Removed)> wrote in message
>> news:A38173C2-102E-492E-A50E-(E-Mail Removed)...
>> > Any suggestions on adding that extra column to my Rowsource??
>> >
>> > This is my RowSource:
>> > TRANSFORM Sum([Heads]) AS [SumOfHeads] SELECT [Period] FROM
>> > [Rept#001_Table]
>> > GROUP BY [Period] PIVOT [Program];
>> >
>> > Thank You,
>> >
>> > Gary
>> >
>> >
>> > "Duane Hookom" wrote:
>> >
>> >> You might be able to add another column to your Row Source like:
>> >> Field: Man Level: 24
>> >>
>> >>
>> >> --
>> >> Duane Hookom
>> >> MS Access MVP
>> >>
>> >> "Gary" <(E-Mail Removed)> wrote in message
>> >> news:E3A97ED3-7A64-4C66-A399-(E-Mail Removed)...
>> >> >I am able to add a graph that produces a chart for me on a report
>> >> >with
>> >> >no
>> >> > problem.
>> >> >
>> >> > The type of graph I am using is line a multiple layer (with each
>> >> > layer)
>> >> > indicating a project manpower requirement. The vertical axis if the
>> >> > total
>> >> > manpower. I like to add a horizontal line (i.e. 24 man level)
>> >> > across
>> >> > the
>> >> > grahic to show the maximum manpower available.
>> >> >
>> >> > How can I do this. I have seen vba code adding Trendlines to the
>> >> > graph
>> >> > object.
>> >> >
>> >> > Thanks,
>> >> >
>> >> > Gary
>> >>
>> >>
>> >>
>>
>>
>>

I don't see that query. This is what I have in the RowSource:

TRANSFORM Sum([Heads]) AS [SumOfHeads] SELECT [Period], 24 As [Man Level]
FROM [Rept#002_Table] GROUP BY [Period], 24 PIVOT [Program];

This is what is in Rept#002_Table:

Program Heads Period
CMIS 0.29 1/14/2007
CMIS 0.29 2/14/2007
CMIS 0.18 3/14/2007
CMIS 0.14 4/14/2007
CMIS 0 5/14/2007
Crew Exploration Vehicle NF 6/14/2006
Crew Exploration Vehicle NF 7/14/2006
Crew Exploration Vehicle NF 8/14/2006
Crew Exploration Vehicle NF 9/14/2006
Crew Exploration Vehicle NF 10/14/2006
Crew Exploration Vehicle NF 1 11/14/2006
Crew Exploration Vehicle NF 1 12/14/2006
Crew Exploration Vehicle NF 2 1/14/2007
Crew Exploration Vehicle NF 2 2/14/2007
Crew Exploration Vehicle NF 2 3/14/2007
Crew Exploration Vehicle NF 2 4/14/2007
Crew Exploration Vehicle NF 2 5/14/2007
Firmware Test Bed 2.3 6/14/2006
Firmware Test Bed 2.3 7/14/2006
Firmware Test Bed 2.3 8/14/2006
Firmware Test Bed 2.3 9/14/2006

What I see in the graph is that it made every period (the date month by
month) 24 Heads (this is my manpower level). So the graph has a baseline
starting at 24 heads and all of the other data is stacked above it.
Remember heads is vertical and period is horizontal.

So its looks like a flat 24 heads for 12 months (that the spand of my
period) as the first layer. The next program which has a head could of 1 is
on top of it, and each program is layered on top.

Any Suggestions?

Thanks,

Gary




"Duane Hookom" wrote:

> I really don't know what your data looks like. The query I suggested should
> have created a new column in your query (did it?) that could be graphed.
>
> --
> Duane Hookom
> MS Access MVP
>
> "Gary" <(E-Mail Removed)> wrote in message
> news:CB7B32CD-52B8-4947-8982-(E-Mail Removed)...
> >I just noticed that it added 24 man level to graph which increased my over
> > all man level by 24. Not quite what I needed. I needed a line going
> > across
> > at the 24 man level without increasing the over man level.
> >
> >
> > Thanks,
> >
> > Gary
> >
> >
> >
> > "Duane Hookom" wrote:
> >
> >> TRANSFORM Sum([Heads]) AS [SumOfHeads]
> >> SELECT [Period] , 24 As [Man level]
> >> FROM [Rept#001_Table]
> >> GROUP BY [Period], 24
> >> PIVOT [Program];
> >>
> >> --
> >> Duane Hookom
> >> MS Access MVP
> >>
> >>
> >> "Gary" <(E-Mail Removed)> wrote in message
> >> news:A38173C2-102E-492E-A50E-(E-Mail Removed)...
> >> > Any suggestions on adding that extra column to my Rowsource??
> >> >
> >> > This is my RowSource:
> >> > TRANSFORM Sum([Heads]) AS [SumOfHeads] SELECT [Period] FROM
> >> > [Rept#001_Table]
> >> > GROUP BY [Period] PIVOT [Program];
> >> >
> >> > Thank You,
> >> >
> >> > Gary
> >> >
> >> >
> >> > "Duane Hookom" wrote:
> >> >
> >> >> You might be able to add another column to your Row Source like:
> >> >> Field: Man Level: 24
> >> >>
> >> >>
> >> >> --
> >> >> Duane Hookom
> >> >> MS Access MVP
> >> >>
> >> >> "Gary" <(E-Mail Removed)> wrote in message
> >> >> news:E3A97ED3-7A64-4C66-A399-(E-Mail Removed)...
> >> >> >I am able to add a graph that produces a chart for me on a report
> >> >> >with
> >> >> >no
> >> >> > problem.
> >> >> >
> >> >> > The type of graph I am using is line a multiple layer (with each
> >> >> > layer)
> >> >> > indicating a project manpower requirement. The vertical axis if the
> >> >> > total
> >> >> > manpower. I like to add a horizontal line (i.e. 24 man level)
> >> >> > across
> >> >> > the
> >> >> > grahic to show the maximum manpower available.
> >> >> >
> >> >> > How can I do this. I have seen vba code adding Trendlines to the
> >> >> > graph
> >> >> > object.
> >> >> >
> >> >> > Thanks,
> >> >> >
> >> >> > Gary
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

The query is your row source property of the chart. Are you just wanting to
add 24 to the result of your sum of Heads?

--
Duane Hookom
MS Access MVP

"Gary" <(E-Mail Removed)> wrote in message
news:A4150133-69EE-44EB-B49B-(E-Mail Removed)...
>I don't see that query. This is what I have in the RowSource:
>
> TRANSFORM Sum([Heads]) AS [SumOfHeads] SELECT [Period], 24 As [Man Level]
> FROM [Rept#002_Table] GROUP BY [Period], 24 PIVOT [Program];
>
> This is what is in Rept#002_Table:
>
> Program Heads Period
> CMIS 0.29 1/14/2007
> CMIS 0.29 2/14/2007
> CMIS 0.18 3/14/2007
> CMIS 0.14 4/14/2007
> CMIS 0 5/14/2007
> Crew Exploration Vehicle NF 6/14/2006
> Crew Exploration Vehicle NF 7/14/2006
> Crew Exploration Vehicle NF 8/14/2006
> Crew Exploration Vehicle NF 9/14/2006
> Crew Exploration Vehicle NF 10/14/2006
> Crew Exploration Vehicle NF 1 11/14/2006
> Crew Exploration Vehicle NF 1 12/14/2006
> Crew Exploration Vehicle NF 2 1/14/2007
> Crew Exploration Vehicle NF 2 2/14/2007
> Crew Exploration Vehicle NF 2 3/14/2007
> Crew Exploration Vehicle NF 2 4/14/2007
> Crew Exploration Vehicle NF 2 5/14/2007
> Firmware Test Bed 2.3 6/14/2006
> Firmware Test Bed 2.3 7/14/2006
> Firmware Test Bed 2.3 8/14/2006
> Firmware Test Bed 2.3 9/14/2006
>
> What I see in the graph is that it made every period (the date month by
> month) 24 Heads (this is my manpower level). So the graph has a baseline
> starting at 24 heads and all of the other data is stacked above it.
> Remember heads is vertical and period is horizontal.
>
> So its looks like a flat 24 heads for 12 months (that the spand of my
> period) as the first layer. The next program which has a head could of 1
> is
> on top of it, and each program is layered on top.
>
> Any Suggestions?
>
> Thanks,
>
> Gary
>
>
>
>
> "Duane Hookom" wrote:
>
>> I really don't know what your data looks like. The query I suggested
>> should
>> have created a new column in your query (did it?) that could be graphed.
>>
>> --
>> Duane Hookom
>> MS Access MVP
>>
>> "Gary" <(E-Mail Removed)> wrote in message
>> news:CB7B32CD-52B8-4947-8982-(E-Mail Removed)...
>> >I just noticed that it added 24 man level to graph which increased my
>> >over
>> > all man level by 24. Not quite what I needed. I needed a line going
>> > across
>> > at the 24 man level without increasing the over man level.
>> >
>> >
>> > Thanks,
>> >
>> > Gary
>> >
>> >
>> >
>> > "Duane Hookom" wrote:
>> >
>> >> TRANSFORM Sum([Heads]) AS [SumOfHeads]
>> >> SELECT [Period] , 24 As [Man level]
>> >> FROM [Rept#001_Table]
>> >> GROUP BY [Period], 24
>> >> PIVOT [Program];
>> >>
>> >> --
>> >> Duane Hookom
>> >> MS Access MVP
>> >>
>> >>
>> >> "Gary" <(E-Mail Removed)> wrote in message
>> >> news:A38173C2-102E-492E-A50E-(E-Mail Removed)...
>> >> > Any suggestions on adding that extra column to my Rowsource??
>> >> >
>> >> > This is my RowSource:
>> >> > TRANSFORM Sum([Heads]) AS [SumOfHeads] SELECT [Period] FROM
>> >> > [Rept#001_Table]
>> >> > GROUP BY [Period] PIVOT [Program];
>> >> >
>> >> > Thank You,
>> >> >
>> >> > Gary
>> >> >
>> >> >
>> >> > "Duane Hookom" wrote:
>> >> >
>> >> >> You might be able to add another column to your Row Source like:
>> >> >> Field: Man Level: 24
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Duane Hookom
>> >> >> MS Access MVP
>> >> >>
>> >> >> "Gary" <(E-Mail Removed)> wrote in message
>> >> >> news:E3A97ED3-7A64-4C66-A399-(E-Mail Removed)...
>> >> >> >I am able to add a graph that produces a chart for me on a report
>> >> >> >with
>> >> >> >no
>> >> >> > problem.
>> >> >> >
>> >> >> > The type of graph I am using is line a multiple layer (with each
>> >> >> > layer)
>> >> >> > indicating a project manpower requirement. The vertical axis if
>> >> >> > the
>> >> >> > total
>> >> >> > manpower. I like to add a horizontal line (i.e. 24 man level)
>> >> >> > across
>> >> >> > the
>> >> >> > grahic to show the maximum manpower available.
>> >> >> >
>> >> >> > How can I do this. I have seen vba code adding Trendlines to
>> >> >> > the
>> >> >> > graph
>> >> >> > object.
>> >> >> >
>> >> >> > Thanks,
>> >> >> >
>> >> >> > Gary
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

I just wanted to and an extra horizontal axis to my graph. My graph
currently have the norizontal axis showing every 5 heads. So it goes from 0,
5, 10, 15, 20, 25, 30, etc.

I wanted to draw a horizonal line at the 24 head count level horizonally
across the graph. That will show the maximum people a this department has on
its staff. I would also like a way to label as "Roster"


Thank You,

Gary

"Duane Hookom" wrote:

> The query is your row source property of the chart. Are you just wanting to
> add 24 to the result of your sum of Heads?
>
> --
> Duane Hookom
> MS Access MVP
>
> "Gary" <(E-Mail Removed)> wrote in message
> news:A4150133-69EE-44EB-B49B-(E-Mail Removed)...
> >I don't see that query. This is what I have in the RowSource:
> >
> > TRANSFORM Sum([Heads]) AS [SumOfHeads] SELECT [Period], 24 As [Man Level]
> > FROM [Rept#002_Table] GROUP BY [Period], 24 PIVOT [Program];
> >
> > This is what is in Rept#002_Table:
> >
> > Program Heads Period
> > CMIS 0.29 1/14/2007
> > CMIS 0.29 2/14/2007
> > CMIS 0.18 3/14/2007
> > CMIS 0.14 4/14/2007
> > CMIS 0 5/14/2007
> > Crew Exploration Vehicle NF 6/14/2006
> > Crew Exploration Vehicle NF 7/14/2006
> > Crew Exploration Vehicle NF 8/14/2006
> > Crew Exploration Vehicle NF 9/14/2006
> > Crew Exploration Vehicle NF 10/14/2006
> > Crew Exploration Vehicle NF 1 11/14/2006
> > Crew Exploration Vehicle NF 1 12/14/2006
> > Crew Exploration Vehicle NF 2 1/14/2007
> > Crew Exploration Vehicle NF 2 2/14/2007
> > Crew Exploration Vehicle NF 2 3/14/2007
> > Crew Exploration Vehicle NF 2 4/14/2007
> > Crew Exploration Vehicle NF 2 5/14/2007
> > Firmware Test Bed 2.3 6/14/2006
> > Firmware Test Bed 2.3 7/14/2006
> > Firmware Test Bed 2.3 8/14/2006
> > Firmware Test Bed 2.3 9/14/2006
> >
> > What I see in the graph is that it made every period (the date month by
> > month) 24 Heads (this is my manpower level). So the graph has a baseline
> > starting at 24 heads and all of the other data is stacked above it.
> > Remember heads is vertical and period is horizontal.
> >
> > So its looks like a flat 24 heads for 12 months (that the spand of my
> > period) as the first layer. The next program which has a head could of 1
> > is
> > on top of it, and each program is layered on top.
> >
> > Any Suggestions?
> >
> > Thanks,
> >
> > Gary
> >
> >
> >
> >
> > "Duane Hookom" wrote:
> >
> >> I really don't know what your data looks like. The query I suggested
> >> should
> >> have created a new column in your query (did it?) that could be graphed.
> >>
> >> --
> >> Duane Hookom
> >> MS Access MVP
> >>
> >> "Gary" <(E-Mail Removed)> wrote in message
> >> news:CB7B32CD-52B8-4947-8982-(E-Mail Removed)...
> >> >I just noticed that it added 24 man level to graph which increased my
> >> >over
> >> > all man level by 24. Not quite what I needed. I needed a line going
> >> > across
> >> > at the 24 man level without increasing the over man level.
> >> >
> >> >
> >> > Thanks,
> >> >
> >> > Gary
> >> >
> >> >
> >> >
> >> > "Duane Hookom" wrote:
> >> >
> >> >> TRANSFORM Sum([Heads]) AS [SumOfHeads]
> >> >> SELECT [Period] , 24 As [Man level]
> >> >> FROM [Rept#001_Table]
> >> >> GROUP BY [Period], 24
> >> >> PIVOT [Program];
> >> >>
> >> >> --
> >> >> Duane Hookom
> >> >> MS Access MVP
> >> >>
> >> >>
> >> >> "Gary" <(E-Mail Removed)> wrote in message
> >> >> news:A38173C2-102E-492E-A50E-(E-Mail Removed)...
> >> >> > Any suggestions on adding that extra column to my Rowsource??
> >> >> >
> >> >> > This is my RowSource:
> >> >> > TRANSFORM Sum([Heads]) AS [SumOfHeads] SELECT [Period] FROM
> >> >> > [Rept#001_Table]
> >> >> > GROUP BY [Period] PIVOT [Program];
> >> >> >
> >> >> > Thank You,
> >> >> >
> >> >> > Gary
> >> >> >
> >> >> >
> >> >> > "Duane Hookom" wrote:
> >> >> >
> >> >> >> You might be able to add another column to your Row Source like:
> >> >> >> Field: Man Level: 24
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Duane Hookom
> >> >> >> MS Access MVP
> >> >> >>
> >> >> >> "Gary" <(E-Mail Removed)> wrote in message
> >> >> >> news:E3A97ED3-7A64-4C66-A399-(E-Mail Removed)...
> >> >> >> >I am able to add a graph that produces a chart for me on a report
> >> >> >> >with
> >> >> >> >no
> >> >> >> > problem.
> >> >> >> >
> >> >> >> > The type of graph I am using is line a multiple layer (with each
> >> >> >> > layer)
> >> >> >> > indicating a project manpower requirement. The vertical axis if
> >> >> >> > the
> >> >> >> > total
> >> >> >> > manpower. I like to add a horizontal line (i.e. 24 man level)
> >> >> >> > across
> >> >> >> > the
> >> >> >> > grahic to show the maximum manpower available.
> >> >> >> >
> >> >> >> > How can I do this. I have seen vba code adding Trendlines to
> >> >> >> > the
> >> >> >> > graph
> >> >> >> > object.
> >> >> >> >
> >> >> >> > Thanks,
> >> >> >> >
> >> >> >> > Gary
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>