two scatter plots with two trendlines on one chart
I know how to do a scatter plot and create a trend line for it. Straightforward graphing function. However, I have *two* data sets (with different number of data points) that I would like to compare. Obviously, I can do a chart for each and put them side by side. Problem: I would like to display a scatter plot for each set with a trend line for each on the *same* chart using Excel 2000. Thanks. -- ================================================= Do you like wine? Do you live in South Florida? Visit the MIAMI WINE TASTERS group at http://groups.yahoo.com/group/miamiWINE ================================================= |
two scatter plots with two trendlines on one chart
Create an "XY (Scatter)" chart with one of the data sets. Select the
chart and "Chart|Add Data" to add the second data series; make sure that the "Categories (X Values) in First Column" option is checked, if appropriate. Select one of the data sets on the chart and "Chart|Add Trendline" to add a trendline for that data set only. Repeat for the other data set. Jerry Leo Bueno wrote: I know how to do a scatter plot and create a trend line for it. Straightforward graphing function. However, I have *two* data sets (with different number of data points) that I would like to compare. Obviously, I can do a chart for each and put them side by side. Problem: I would like to display a scatter plot for each set with a trend line for each on the *same* chart using Excel 2000. Thanks. |
All times are GMT +1. The time now is 08:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com