Drawing a constant Trendline

[Gary]

I am using a stacked area chart. The vertical axis is # of people and the
horizontal line is time. I want to draw something line a trendline at a
given # of people level across the complete chart.

For example, I want a horizontal line at the 12 people level straight line
across the chart.

Can anyone help.

Thanks,

GAW

 

[Al Camp]

Gary,
Add a calculated field to the query behind your Graph
PeopleStandard : 12
Plot that value on your chart.
It may plot as an area, so select the series, go to ChartType, and select Line. Adjust
the line format to suit...
That should display a horizontal straight line across the chart.

An excellent sight for charting is
http://peltiertech.com/Excel/Charts/index.html

 

[Gary]

This is my RowSource:

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


Are you indicating that I should do the following to my RowSource:

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

You are correct, this does plot a baseline area graph of 12 man level and
all of the other graphs are layered on top of this.

Are you indicating that I should select the new baseline area graph and
select it and change the Chart Type. Can this be done in a Report or must I
do this in a Form or either will work too.

I am not sure how to select the Series and change the Chart Type. How would
I do this??


Thank You!

 

[Al Camp]

Gary,
The SQL appears OK... As long as every value to be plotted has a 12 associated with
it.

When you first add the 12 series, it may show on the chart as an area... just like the
others.
In "Graph" design mode (not the report), select just the 12 series, then select
Format/FormatDataSeries, and change the ChartType to Line.
That should change just the 12 values to Line, and not affect your areas.
That line should overlay your area plots.

As I mentioned earlier, an excellent site for charting is
http://peltiertech.com/Excel/Charts/index.html

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

This is my RowSource:

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


Are you indicating that I should do the following to my RowSource:

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

You are correct, this does plot a baseline area graph of 12 man level and
all of the other graphs are layered on top of this.

Are you indicating that I should select the new baseline area graph and
select it and change the Chart Type. Can this be done in a Report or must I
do this in a Form or either will work too.

I am not sure how to select the Series and change the Chart Type. How would
I do this??


Thank You!

Gary,
Add a calculated field to the query behind your Graph
PeopleStandard : 12
Plot that value on your chart.
It may plot as an area, so select the series, go to ChartType, and select Line.
Adjust
the line format to suit...
That should display a horizontal straight line across the chart.

An excellent sight for charting is
http://peltiertech.com/Excel/Charts/index.html

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Gary]

Thank You!!

It works. I finally understood what you were saying in the posting.

Gary

Gary,
The SQL appears OK... As long as every value to be plotted has a 12 associated with
it.

When you first add the 12 series, it may show on the chart as an area... just like the
others.
In "Graph" design mode (not the report), select just the 12 series, then select
Format/FormatDataSeries, and change the ChartType to Line.
That should change just the 12 values to Line, and not affect your areas.
That line should overlay your area plots.

As I mentioned earlier, an excellent site for charting is
http://peltiertech.com/Excel/Charts/index.html

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

This is my RowSource:

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


Are you indicating that I should do the following to my RowSource:

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

You are correct, this does plot a baseline area graph of 12 man level and
all of the other graphs are layered on top of this.

Are you indicating that I should select the new baseline area graph and
select it and change the Chart Type. Can this be done in a Report or must I
do this in a Form or either will work too.

I am not sure how to select the Series and change the Chart Type. How would
I do this??


Thank You!

Gary,
Add a calculated field to the query behind your Graph
PeopleStandard : 12
Plot that value on your chart.
It may plot as an area, so select the series, go to ChartType, and select Line.
Adjust
the line format to suit...
That should display a horizontal straight line across the chart.

An excellent sight for charting is
http://peltiertech.com/Excel/Charts/index.html

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I am using a stacked area chart. The vertical axis is # of people and the
horizontal line is time. I want to draw something line a trendline at a
given # of people level across the complete chart.

For example, I want a horizontal line at the 12 people level straight line
across the chart.

Can anyone help.

Thanks,

GAW

 

[Al Camp]

Good deal!
Al

Thank You!!

It works. I finally understood what you were saying in the posting.

Gary

Gary,
The SQL appears OK... As long as every value to be plotted has a 12 associated
with
it.

When you first add the 12 series, it may show on the chart as an area... just like
the
others.
In "Graph" design mode (not the report), select just the 12 series, then select
Format/FormatDataSeries, and change the ChartType to Line.
That should change just the 12 values to Line, and not affect your areas.
That line should overlay your area plots.

As I mentioned earlier, an excellent site for charting is
http://peltiertech.com/Excel/Charts/index.html

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

This is my RowSource:

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


Are you indicating that I should do the following to my RowSource:

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

You are correct, this does plot a baseline area graph of 12 man level and
all of the other graphs are layered on top of this.

Are you indicating that I should select the new baseline area graph and
select it and change the Chart Type. Can this be done in a Report or must I
do this in a Form or either will work too.

I am not sure how to select the Series and change the Chart Type. How would
I do this??


Thank You!




:

Gary,
Add a calculated field to the query behind your Graph
PeopleStandard : 12
Plot that value on your chart.
It may plot as an area, so select the series, go to ChartType, and select Line.
Adjust
the line format to suit...
That should display a horizontal straight line across the chart.

An excellent sight for charting is
http://peltiertech.com/Excel/Charts/index.html

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I am using a stacked area chart. The vertical axis is # of people and the
horizontal line is time. I want to draw something line a trendline at a
given # of people level across the complete chart.

For example, I want a horizontal line at the 12 people level straight line
across the chart.

Can anyone help.

Thanks,

GAW