Add baseline to Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 
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...
 
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...
 
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...
 
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...
 
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...
 
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

Access Combination Chart Types Access 2010 0
Graphs and charts in Access 2007 0
Excel chart, set a vertical baseline on a certain date 0
MS Graph: positioning items on x-axis 7
Drawing a constant Trendline 5
How to add to existing graph? 1
Chart 1
Cannot get graph to work properly 1

Back
Top