How do I get a trendline for all data series, instead of just one.

I need to retrieve R squared values, and trendline information for all data 
series within a block of data.  Excel is only letting me get trendline 
information on one data series, which is almost useless for me.
0
Darling (3)
12/14/2004 10:01:03 PM
excel.charting 18370 articles. 0 followers. Follow

1 Replies
605 Views

Similar Articles

[PageSpeed] 0

Dave Darling  -

>I need to retrieve R squared values, and trendline information for all data 
>series within a block of data.  Excel is only letting me get trendline 
>information on one data series, which is almost useless for me.<

You can add a trendline and get R squared for each data series.

If you need a trendline for the combination of several data series, you 
could copy data into a column containing all combined data, plot that 
combined data series as a separate series, and add a trendline.

-  Mike

www.mikemiddleton.com 


0
middleton1 (108)
12/15/2004 2:03:55 AM
Reply:

Similar Artilces:

How large can the MS Money software ITSELF get, over time? (plz re
I've been using MS Money for years. The last time I upgraded it was to Small Business v 2006 as I run a small business from my home office. I have my pers and bus financials on there since the 90's (not sure of very 1st transaction...). Features-wise, there's no reason for me to upgrade or change anything, and, I also on occasion need to view certain Reports which by nature need to include data from old now-closed bank and credit card accounts so I do not want to "archive" anything at all. But.. I'm wondering, how long can this go on? that is, entering financia...

deleting data, keep formulas
I want to delete the data in a worksheet, but keep the formulas so tha I have a worksheet pattern of formulas that I use frequently -- elviejo4 ----------------------------------------------------------------------- elviejo41's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2356 View this thread: http://www.excelforum.com/showthread.php?threadid=39389 Cells.SpecialCells(xlCellTypeConstants, xlNumbers).ClearContents I don't know how large your spreadsheet is, but you could try changin the setting to display Formulas (Tools>Options | View tab, in th Win...

Exporting One File to Two Others
Here's the situation - hopefully someone can answer my question or come up with a better idea. My daughter owns a used book store and has and inventory of over 10,000 books. My thoughts were to have three different files for serch purposes. ie Title, Auther, Subjuct Matter and add a Referance Number to each book. This way if a customer askes for a book, the serch would be easy. The problem lies in the sales. When a customer purchases a book, she would write down the Referance Number on a sheet of paper then at the end of the day, enter all the days Reference Number into the fi...

data validation #26
I have two cells in my spreadsheet where field personnel will enter data. I'm using Data Validation, Allow Date, to control what they enter. The cells are: A1 Year Begin A2 Proposed Year End They will put the year they began in the "Year Begin", but I want to limit what they can enter in "Proposed Year End" to no more than 12 years, that's the max we allow them to take. Under Data, I chose "between". For "Start date" I entered "1/1/2004", just so they don't erroneously type in previous years. For "End date", what do...

Data analysis by 2-dimensional data table + database
Hello, in an old Excel-manual (possibly way back to version 3) by Microsoft there was an excellent example of a 2-dimensional datatable (in German: Mehrfachoperation) with input variables based on database results. Now I would need to apply this technique, but my old manual is lost, and I can't figure out by heart exactly how this was done. Does somebody still have an old manual from which to draw the model, or can let me know the deatils of the trick? Thank you in advance. Kind regards, H.G. Lamy H., I think that you are talking about a cross-tab table....

many-to-one relationship with systemuser
I would like to create a relationship many-to-one where the systemuser is the main part of the relation, but the Microsoft CRM don't show this entity as available. If I go to the systemuser entity and try to make the relation from there the button to add a one-to-many relation does not appear. I have planned to create many relations from custom entities to the Systemuser entity. Is there any solution to that problem? Thanks. Renato. Unfortunately, there is no supported solution for this. the app only allows a single relationship to be added between any 2 entities and there is alr...

group & summarize diff rows of data that have something in common
I am trying to arrange a large amount of data (inventory) in 2 different ways. 1) Group all identical parts into one row and 2) Group all identical locations into one row. I dont know how to do this. I am dealing with over 3,000 rows. Any suggestions? Depending on your workbook layout, you may be able to use a pivot table to summarize the data. There are instructions in Excel's Help, and Jon Peltier has information and links: http://peltiertech.com/Excel/Pivots/pivotstart.htm pkunAAC wrote: > I am trying to arrange a large amount of data (inventory) in 2 different &g...

shading difference between two series
Hi, i'm trying to create a chart that has two data series Y1 and Y2 Whenever Y1 is greater than Y2 I want to shade that region with on color lets say blue. Whenever Y1 is Below Y2 I would like to share th region with another color i.e red. Is there any way to do this? I'v tried duplicating the Y1 and Y2 series and then doing an area fill o the two new added series but I'm left with an area fill below th intersection of these two lines that I dont want. thanks, Da -- ybufal ----------------------------------------------------------------------- ybufalo's Profile: http:...

How can I get Positive values only from the random number generat.
I am generating a random group of numbers using Excel's add-in "Random Number Generator". I am using the normal distribution, but I want positive values only. I know that the test I am doing will work with the negative values I have generated, because the mean/stdev are correct. However, the activity for which the numbers are associated can never be negative, so my presentation will be less effective. Any ideas? You could use the randbetween function and specify a positive range i.e. =Randbetween(1,10000000) HTH Jimbola "Markw3700" wrote: > I am gene...

Excel messes my data up
Hi, I am trying to run vlookup for about 5K cells from range of 20k cells. Now the problem is that some of the cells include only numbers and some both numbers and letters, like AB11002. I also have empty spaces on the data so I have to run trim on both data before running vlookup. Just after trimming both data vlookup runs correctly, but if I "touch" any cell containing only numbers excel propably converts it to number and at this point excel don't think those two cells that before was equal are equal any more. So how in the earth I could convert my mixed data in the format e...

How can I get a unique list of a column?
I have a column which is the name of cities. There are about 5 cities which is repeated in 50 records (rows). I want to get the name of this 5 cities in a separate column. How can I do this? TIA Rasoul Khoshravan Use Data>Filter>Advanced Filter. There is an option to filter unique records. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Yabi" <khoshravan@gmail.com> wrote in message news:1176190587.423150.254060@q75g2000hsh.googlegroups.com... >I have a column which is the name of cities. There are about 5 cities >...

How to update the data of a combo box
In a form I have tab pages One is for consultation data it is a subform link to consultation table. The other page is Examen subform in which you have a combo box that will list the consultations of a client. The problem is when I add a new consultaion record for a client it does not appear in the list. I have to select another client and then come back to the preveous client to see the new entry. For this combo I run Me.my_combo_box.requery on the current and load event. Somehow this does not refresh or update or ??? my list. What should I do ? Thank you. -- eric ...

Data Access Page 09-11-07
Good Morning Community, Is there any way to include a search function on a Data access Page? I have a file that I want to put on a Data access page that will be published on a shared drive, the problem is that the file has about 1000 records and to search through each one would defeat the purpose of putting the page up. Is there anyway to include a search function that would jump to a particular record as access does on its forms. Thanks in advance for any response Perhaps this sample database will serve as a starting point: http://www.cadellsoftware.org/SampleDBs.htm#FilterDAP...

BOM print in graphics mode missing data
We are using GP 8 SP 2. When we print a BOM in text mode, everything prints fine but it graphics mode, each page is missing several lines of data as if it expects the page to be longer than 11". Does anyone know of a fix for this? Thanks. ...

how do I link a text box on a chart to a specific data point?
I have a text box in a chart that I want to move with the data, as additional data is added to the chart. For instance, if the datapoint is January 5, 2008, as I add additional days, I want the text box associated with the January 5, 2008 datapoint to move with the graph. Hi, Text boxes don't track with the data. Replace the text box with a Data Label. Select a single point in a series that is near the location of the text box. Choose Format, Selected Data Point, on the Data Labels tab turn on Value. Click OK. Select the data label and type the text that was in the Text box. ...

How do I compare item text of combobox to one string
Hello all experts I have used combobox I ms Access like that Combobox.rowsource="xxxx" combobox.bound Column=2 Limit to List=yes all above it working but I can not get item text of this combobox,so How can I do can you healp me. Thank combobox.value "cambo" wrote: > Hello all experts > I have used combobox I ms Access like that > Combobox.rowsource="xxxx" > combobox.bound Column=2 > Limit to List=yes > all above it working but > I can not get item text of this combobox,so How can I do > can you healp me. > Thank > > > ...

system hibernates just after start up
Hello: from time to time, when I start up my laptop (from hibernate) it goes again to hibernate just after start up complete. when I start again for the second time, it's OK and I can continue working. is this a sign of a malware or virus? is there any fix for that? thank you Maurice Not necessarily I'd disable Hibernation Reboot the PC (This should clean the Hibernation Folder) Then Enable it again And see if that helps Russ -- Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist SBS2003 SBS2008 Sup...

Can not get Excel macros to format/save charts--help??? :(((((
Help??:((( I've spent the last 5 days searching on this forum for problems similar to what I have but no luck! I am trying to use Excel macro to create a simple bar chart and to format the chart type/etc...but the macro keeps erroring when I try to run it. The debug points to " ' Set ActiveChart = ActiveSheet.ChartObjects(Chart1)" run time error 1004. No matter what I name the chart, it errors. I'm advanced at Excel but not editing macros with VB. I'm at my wits end and hope that someone can help me :(( Hi, You do not set the Activechart ob...

P-V chart, get the last date on the X axis?
In a Price-Volume chart, how do you get the last date of your data on the X axis to show up? Here's one way: http://www.arouet.net/archives/2004/08/show_the_datas.php You have to scroll down a bit, the page's layout is a little funny. If you don't care about the first date also showing, here's another way which may be marginally easier: Have your dates in descending order in the sheet. Create your chart. Go to Chart menu > Chart Options > Axes, change Category Axis to Category. Double click the X axis, Scale tab, select Categories in Reverse Order and if desired V...

Import XML data in Excel XP Professional
Hello all, I have a pretty well-formated XML data file and a well designed Excel file (.xls) served as my report template. I would like to import this XML data file into my Excel template. So, the Excel Template will do the Totals and subtotals of the XML data for me. How do I do so in Excel XP Professional version? Thank you sooooooo much~~~~ Annie .. ...

HOW THE HELL Can I get excell to stop ploting blank cells
I am pulling my hair out over this stupid thing. I am using MS Excel 2003 I have a column of data that I am trying to graph the problem is the column derives its data from a formula in the cell if the formula is true than the cell has a visible data value in it if it is false the cell has no visible data value just the formula value that shows as a blank cell except for in the formula window. My problem is that My plot for my chart is from Cells A1 to A50 which all have formulas but only A1 to A20 actualy has visible value in the spread sheet because the rest of the cells have a formua...

Using one column to trigger an other
I know very little about spread sheets as you will soon learn. I am making a spread sheet to sort a grocery list for two different stores by aisle and department. The items to be sorted are in column A, the quantity to purchase in column B, the aisle #s in column C for one store and D for the other. I want to be able to impute in Column B and only sort the imputed cells row in Column C and D. This will produce a printable list of only the item want in a sorted list for either store. I have the spread sheet and can sort each column but when I sort it I also get the un-marked rows of colum...

specific data points in data range
Hi all and happy new year. Is it possible to plot certain points and then a range of data on one series line and if so how ? Basically I have 4 years of data (monthly) but now want to report jan & Jul results for 2006 - 2008 and then all of 2009 data. thanks in anticipation Roy -- thanks Roy ...

Can get new messages in center of screen?
Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Email Client: pop I'm on new imac 27&quot; <br> Boy, open new mail message and it shoots over to the left side of the monitor. Wasn't so bad with 20 CTR. <br> Anyway to get them to be centered? thanks! > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3343028456_1486606 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: 8bit On 12/6/09 9:19 PM, in...

How do I get the sum of only odd/even numbered cells in a column?
I need help with the formula to sum up only the odd or even numbers in a column. I appreciate any help that you can provide. Thanks, Steve One way, even =SUMPRODUCT(--(MOD(A1:A10,2)=0),A1:A10) odd =SUMPRODUCT(--(MOD(A1:A10,2)=1),A1:A10) -- Regards, Peo Sjoblom "Steve E" <Steve E@discussions.microsoft.com> wrote in message news:0C3FAA07-2E0D-458B-ADFB-9EF27286C60C@microsoft.com... > I need help with the formula to sum up only the odd or even numbers in a > column. I appreciate any help that you can provide. > > Thanks, > Steve =SUM(IF(MOD(A1:A10...