Add baseline to Chart

G

Gary

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
 
D

Duane Hookom

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

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
 
D

Duane Hookom

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 said:
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 said:
You might be able to add another column to your Row Source like:
Field: Man Level: 24
Click to expand...
Click to expand...
 
G

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 said:
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 said:
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 said:
You might be able to add another column to your Row Source like:
Field: Man Level: 24


--
Duane Hookom
MS Access MVP

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
Click to expand...
Click to expand...
Click to expand...
 
G

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 said:
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 said:
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 said:
You might be able to add another column to your Row Source like:
Field: Man Level: 24


--
Duane Hookom
MS Access MVP

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
Click to expand...
Click to expand...
Click to expand...
 
D

Duane Hookom

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 said:
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 said:
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 said:
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


:

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


--
Duane Hookom
MS Access MVP

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
Click to expand...
Click to expand...
Click to expand...
 
G

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 said:
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 said:
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 said:
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


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


:

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


--
Duane Hookom
MS Access MVP

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
Click to expand...
Click to expand...
Click to expand...
 
D

Duane Hookom

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 said:
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 said:
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 said:
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



:

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


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


:

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


--
Duane Hookom
MS Access MVP

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
Click to expand...
Click to expand...
Click to expand...
 
G

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 said:
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 said:
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 said:
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

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



:

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


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


:

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


--
Duane Hookom
MS Access MVP

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
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a chart from a table in word thats dynamic 0
Getting the graph style I want 4
Move Chart with Text 0
Excel chart, set a vertical baseline on a certain date 1
Crosstab query (?) chart 0
Selecting Chart Type 0
How to add to existing graph? 1
simple chart 0

Top