I am trying to set up a graph in MS Excel where you can enter in the values for X and B and it will. Need to calculate the first and last points on the line and plot them as an 'XY (Scatter)' chart with points connected by a line. Automatically Updating y=mx+b Formula from Scatterplot Trendline Hey everyone, I have automatically updating columns that throw numbers into an XY-scatterplot where I take the line-of-best-fit to give me a y=mx+b formula, so that I can plug in my 'x' to get the 'y' I'm looking for in each row.
Hey everyone, I'm really hoping someone can help me with this. I need to plot percentages over time in a line graph in excel. I don't want to have to do a percentage equation in the spreadsheet, I just want excel to take two sets of values and display the percentage in the chart. For example, I need B1 as a percentage of B2 for week 1, C1 as a percentage of C2 for week 2, etc.
Can someone please offer a suggestion for how to do this? I would really appreciate it. Also, would it be possible to link data from other sheets in the workbook into one single chart? Hi guys, would really appreciate anyones help with this. I have a column full of text-formatted fractions.
4/5 6/4 3/1 2/5 4/5 etc, etc.the column is very long!! I need to convert these to actual fractions.ones I can add to equations, allowing me to multiply and add. If I highlight the column and goto 'format Cells' and change to fraction, the values still stay in the left of the cell.its only when I manually click on each individual cell, then tick the little green tick, does the cell validate, and the value in the cell moves to the right (and is therefore a proper value).problem is I have to keep doing this for each individual cell.and I have 70000+ cells in this column! Any suggestions on how I could speed this up? I did a search in here but didn't find an answer so here goes nothing.
I have a spreadsheet with data from A1 to H1 down to A275 to H275. I select all of it, Copy, go into the Sheet2 tab and select A1, Paste Special - Transpose and it give me the following error message: Quote: The information cannot be pasted because the Copy area and the paste area are not the same size and shape. Try one of the following: - Click a single cell, and then paste.
Select a rectangle that's the same size and shape, and then paste. For the life of me, I can't figure out why it's not working! I have done this many times with other spreadsheets. Has anyone ever experienced this? If so, were you able to resolve it and how? Many Thanks, Mike.
Hi there, I'm very new to Excel, and I'm having trouble figuring a few things out. Hopefully this will be very easy for you guys! In Sheet 1, I have a column of cells that I would like to also appear in Sheet 2. If I add a new row to the column in Sheet 1, I would also like it to be updated automatically in Sheet 2. Currently, I can get it to show the contents of individual cells from Sheet 1 in Sheet 2 by using this formula in the formula bar for each cell in Sheet 2: =Sheet1!A3 (or whichever cell it is) That's fine, but I'd like to just have a formula that will reproduce the entire column (ie. Without a fixed range, as new rows are going to be added to the column).
If anyone could point me in the right direction, I'd be very very grateful. Hi peeps I want to combine data from several worksheets into one worksheet. For example, I have data in Sheet1 (Columns A,B,C), data in Sheet2 (Columns A,B,C), data in Sheet3 (Columns A,B,C) all with varying amounts of rows. (All the rows contain text data). I need to combine all of the data from the 3 sheets into a single sheet, Sheet4 (Columns A,B,C), eliminating the empty rows. I've been looking into this for a while, and can't find anything that really helps. Anyone got any pointers of what to look into?
Any help will be beautiful. I have never really used VBA and so am completely stuck at this problem. I need to create a macro which auto-populates a master worksheet from the individual user sheets in a shared workbook. Sheet 1 is the master sheet 'Team Stats'. There will be an undetermined number of individual worksheets to accomodate new staff.
Each worksheet will be identical, using columns A-I with row 1 having the headings: Date, Name, Reference, Value, Price, Age, Purchased?, Destination, Add. Products (the last 3 columns will have a drop-down list which will be used to enter data into the cell). There will be a varying number of rows in each of the individual sheets. If possible I would like the macro to run every time data is entered into one of the individual worksheets. If this is not then it would be fien to update every time the workbook is opened. If anyone can help it would really cut down the time I spend collating these stats every day!
I've been using Excel for years and had very few issues. However, I recently went into a spreadsheet to update it and was unable to select and enter data into an individual cell. When I click on a cell and try to enter #s nothing happens (my num lock is on). Then when I try to click into another cell it just highlights that cell, along with any other that I move my cursor over. Once I click on one cell I can't stop the highlighting from happening.
I can't even click on anything in the toolbar. I am extremely confused, can anyone help? I would like to copy a small table from Word into one cell in an Excel worksheet. The first column of the table is a list of numbers. I tried converting the table into text with manual line breaks and tab stops to divide columns and rows, but that didn't solve my problem. Excel pastes the data into several rows.
When I try to merge them, I get a warning that the selection contains multiple data values, and merging into one cell keeps the upper-left most data only. What I tried that didn't work:.
Formatting the Excel cells as text before pasting the data. The various options for 'Paste Special.'
The closest I got was inserting the table as a Document Object, which could be a workaround, I guess. What I am saving for when all else fails:. The obvious solution of copying row by row into one Excel cell. The data in the table is information about my dad's medications. I would like to have reference charts of how to identify the strength of each tablet by its color and markings.
I got the info from the manufacturers' websites and entered it into tables in Word, which I would like to copy into a more comprehensive file I am creating in Excel. The first column of each table is the strength of the tablet, entered as 1 mg., 2 mg., etc. The subsequent columns describe the shape, color, and markings.
There are 3 tables, each with about 4-5 rows. Is there a way to copy each one - whether as a table or as text - into a single Excel cell without losing data? Also, I cannot move the Pivot Table from the new Worksheet it is created in, to my existing Worksheet. I am running Excel 2011 for Mac.
I have a Worksheet with a small amount of data, and when I click the Pivot Table button it automatically creates the Pivot Table in a new Worksheet. The Pivot Table data is fine, but I want it to display alongside the source data.
I've tried using the Move Pivot Table option and choosing to Create Pivot Table in Existing Worksheet and choosing a source cell alongside my current data, but nothing appears. Also, I checked in Edit menu and found that the Pivot Table appears to have not even been created/moved because there is no option to undo it. Appreciate any help, let me know if you have any further questions.
Today I ran into an odd problem. I typed in values for column A rows 1 through 10 then values for column B rows 1 through 10. Then in column C, I made the formula C1=A1/B1. The math was correct it showed 542 in the C1 cell.
So I dragged that formula down and it showed 542 in all column C cells which is not correct. And when I went to check to see if the formula was correctly dragged it was. For instance, the formula in C2 is =A2/B2 however the value of that cell showed 542 which was not the correct math/value. But it gets even more weird.
When I click on the Column C cells and then it shows the formula up top in the formula bar and if I put my cursor anywhere in the formula bar and hit Return the formula does not change however the correct value then appears in the Column C cell. It is like the act of putting the cursor in the formula activates it to work properly but until it is activated that C cell shows the value of the cell which it was dragged down from. This is quite bizarre. Has anyone ever seen this before? I have no idea what is going on. I ran a scan for viruses and none were found.
I tried it on several new/different spreadsheets but it keeps happening. Thanks for any tips on this.
I have a question regarding filtering of columns, hopefully someone is able to put me on the right track. I have set up Excel 2007 so that I can click on the drop-down menu in each column to filter them. However, in my data set there is one blank row separating two set of rows. Now, when I apply the filter on a column, all the rows above the blank row filter correctly, but all the rows below stay un-filtered. I guess Excel only looks at the consequtive rows, then stops when it hits a blank row.
Is there any way of applying the filter beyond a blank row (i.e. The whole column)? Any advice is higly appreciated. I would like the contents of a selected active cell to be displayed in a certain other cell, say R4.
When another cell is selected and active, that cell's contents should be displayed. I have an array of 9 columns and 20 rows with equity symbols and conditionally formatted to show the severity of price movement in either direction. Instead of typing in the value of whatever cell a trader is looking at I would like for them to just be able to click on the cell and have that symbol copied into R4 so some detailed information can be displayed for them. Can't find a thing about this on any forum or msdn. Hope I'm explaining this at least somewhat clearly. Regarding Charts in Excel: Is there a way to have the Min and Max values adjusted dynamically for the Scale of the values being displayed?? I know that I can use named ranges to display various sections of data - month by month, or quarter by quarter, for example.
But when the value of these ranges vary greatly from section to section I end of having to manually go and adjust the Min and Max values of the chart scale. For example, if I was looking at a graph of the S&P 500's prices last November, a Min and Max range of 750 to 1200 would be fine. But if I had a dynamic range established and scrolled over to view the S&P 500's prices for this past February, I would need a Min and Max range of around 650 to 850. Is there a way to have these Min & Max values adjust automatically depending on the values being displayed?? Thanks StanSz.
I have a co-worker's file that he is having trouble with. He is using Excel 2000 SP3. When copying a cell with a formula in it of '=D6+C6' and pasting it into the next cell down, it will display the same value in the cell as the calculated value from above, but has the correct formula displayed in the formula bar of '=D7+C7'. Example: A1: 50 A2: 10 B1: 60 B2: 20 A3: Formula: =A1+A2 Displays: 60 Right click A3, Copy, right click B3, paste A3 displays 60 When I click save, it will change the display value to 80. I am trying this on his workstation and mine.
Mine has Office 2010, so I think there might be an issue with the file itself. Also, not just copy and paste. I can also just click the top cell after filling in the formula and then drag the bottom right of the cell downward and it will do the same of filling in the correct formula, but have the incorrect value. I know that I could get him to just click save each time before really looking at the results, but that is just a band aid to the problem. Any ideas how to fix this? Right now I have a sports league with 8 teams, I'd like to create a random 7-game schedule where each team plays the other team only once.
Essentially this will be a 7-game round robin. However, I'd like to be able to use this for any number of teams and games. I'd like to do this in Excel, but I can't figure out how to have a randomly generating non-repeating macro with text values in cells.
So right now I have a column of 8 values and need matrix of 7 columns by 8 rows next to it. I've found this thread that has one for numbers, but I can't figure out how to do it for text values. Hello all, Until now I have been able to find all my answers through searches.
As a VBA novice, it has been very helpful. I am stumped on this one, however. I am trying to autofill from the selected cell in Column C down. I would like it to stop at the last cell with data in Column B. This is the code I have so far: Range('C2').Select Selection.AutoFill Destination:=Range(Selection, Selection.End(xlDown)) This does the autofill, but doesn't stop at the last cell with data in Column B. In the past I have use this code to acheive similar results: Dim endRow As Long endRow = Cells(Rows.Count, 'B').End(xlUp).Row Range('C2').AutoFill Destination:=Range('C2:C' & endRow) The problem with this code is that I will not always be starting in 'C2'. I need code that uses whatever the selected cell is.
All help is appreciated. I have been using Excel (XP) to make a text chart for several months. Some of my text entries are rather lengthy. The past two weeks these lengthy entries are showing up as pound signs (#########) when I click off the cell.
I know the text will fit in the cell, and the problem isn't solved by making the cell bigger or using a little bit less text. I have the cells formatted as 'text' and 'wrap to fit'. I have printed the pages and the printed version also has pound signs. I just want my text to show up! Is it possible to import a single text file into Excel, splitting the incoming data across multiple worksheets rather than a single worksheet? Each each row on the text file would be evaluated by the value in one of it's 'columns' and written to the appropriate worksheet.
![How to find the equation of a scatter plot How to find the equation of a scatter plot](http://s3.amazonaws.com/libapps/accounts/14039/images/scatter-plot.png)
The file is '!' Delimited and has 11 columns for each row. Currently, I import the file into one worksheet and cut/paste the rows manually into new worksheets/tabs. The files are very large, sometimes exceeding the 65,536 row limit, which I could avoid if the data was split out coming in. Any help anyone could provide would be WONDERFUL.