Thread: Two data sets, one average

Hi all,

I am trying to chart two data sets on a single graph. Using XY scatter, I
can easily graph the data sets (X is time and Y is value in $). My question
is, is there a way to add a trendline that will track the moving average of
the two data sets over time? I have thought that perhaps I need to use a
combination graph, but wanted to hear what the experts out there thought.

Thanks for your help.

I think this will work for you if you wwant to show only the trend line for
the average but not the average itself.

set up a data set for the average you want and plot it.
add the trend line for this data set.
select the data set on the chart and set line and symbol to none.
If you are using the legend, select the line for this added data set ion the
legend and clear all

"SWeyer" wrote:

> Hi all,
>
> I am trying to chart two data sets on a single graph. Using XY scatter, I
> can easily graph the data sets (X is time and Y is value in $). My question
> is, is there a way to add a trendline that will track the moving average of
> the two data sets over time? I have thought that perhaps I need to use a
> combination graph, but wanted to hear what the experts out there thought.
>
> Thanks for your help.

I can't really set up a data set for the average itself, as the two data sets
have different time points associated with the Y values. Each individual
data set is the moving total of dollars over a period of time, with
transactions taking place on different dates for each data set. THerefore, I
need to be able to have two sets of X values, not just one like in a line
graph, and I can't really average the two data sets together, except for a
single point in time (like YTD). I would like to see the moving average.

Thanks

"bj" wrote:

> I think this will work for you if you wwant to show only the trend line for
> the average but not the average itself.
>
> set up a data set for the average you want and plot it.
> add the trend line for this data set.
> select the data set on the chart and set line and symbol to none.
> If you are using the legend, select the line for this added data set ion the
> legend and clear all
>
> "SWeyer" wrote:
>
> > Hi all,
> >
> > I am trying to chart two data sets on a single graph. Using XY scatter, I
> > can easily graph the data sets (X is time and Y is value in $). My question
> > is, is there a way to add a trendline that will track the moving average of
> > the two data sets over time? I have thought that perhaps I need to use a
> > combination graph, but wanted to hear what the experts out there thought.
> >
> > Thanks for your help.

OK, Rather than making the third data set be an average try seting a third
data set with combined data from the two original data sets and doing the
trend line based on this data set. You will probably have to resort sort
this third set by date for every graph to keet the trend line correct.

"SWeyer" wrote:

> I can't really set up a data set for the average itself, as the two data sets
> have different time points associated with the Y values. Each individual
> data set is the moving total of dollars over a period of time, with
> transactions taking place on different dates for each data set. Therefore, I
> need to be able to have two sets of X values, not just one like in a line
> graph, and I can't really average the two data sets together, except for a
> single point in time (like YTD). I would like to see the moving average.
>
> Thanks
>
> "bj" wrote:
>
> > I think this will work for you if you wwant to show only the trend line for
> > the average but not the average itself.
> >
> > set up a data set for the average you want and plot it.
> > add the trend line for this data set.
> > select the data set on the chart and set line and symbol to none.
> > If you are using the legend, select the line for this added data set ion the
> > legend and clear all
> >
> > "SWeyer" wrote:
> >
> > > Hi all,
> > >
> > > I am trying to chart two data sets on a single graph. Using XY scatter, I
> > > can easily graph the data sets (X is time and Y is value in $). My question
> > > is, is there a way to add a trendline that will track the moving average of
> > > the two data sets over time? I have thought that perhaps I need to use a
> > > combination graph, but wanted to hear what the experts out there thought.
> > >
> > > Thanks for your help.