Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting data from another workbook based on variable | Excel Discussion (Misc queries) | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel | |||
Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |