Hi All, Is it possible to easily update the Excel data in a spreadsheet without changing the formatting of a table that I made from that data in Excel? I have two columns and 7 rows of data in percentages (i.e. For each one of the 14 questions from a survey) that I used to make column charts. Is there any easy way to change the data in the cells and just refresh my chart with new data without changing the existing formatting? (If I add the new data, and recreate the chart from scratch, I will have to reformat each of my charts, which I want to avoid). Thanks for your help!!!
Dec 1, 2017 - If you happen to lose important or unsaved Excel files on Mac computer, hard. Crashes and you have important data on the unsaved Excel file. This feature on Excel sheet, you can directly restore unsaved Excel files from.
Hello, I am copying charts to display the same information for different regions. When I work on the copied region, I find it a cumbersome task to go through each charts source data and change the cell references to the different region. Essentially I am doing a trending analysis for each region, with a region having its own sheet with 5 charts per sheet. What I have done is copy the original sheet and am updating the sheet for another regions source data by going to the source data.
The source data is all in the same row/column format, but each regions source data has its own sheet. Is there a more automatic way to do this?
Perhaps a way to update all 5 charts references at the same time. 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:.
![Data Data](/uploads/1/2/5/6/125626254/951236072.jpg)
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? 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? Hello, Firstly i haven't used excel to a great extent since my college days. So i'm having to re-learn 99.9% of everything i once new. I am volunteering for a non profit organization and trying to create a reservation system for the rooms that they have - kind of like hotel software, but in excel (i did a similiar thing in college but for plane seats) Please find it attached. What i need it to do: Copy all of the info from the main page to the guest lit (a new row each time). From the guest list to the Gannt chart - i did a few tutorials on dynamic gantt charts using conditional formatting but cannot get them to work when based on data on a different worksheet.
Finaly is there a way to check for availabilty on any given date? If just someone could point me in the right direction, i would be appreciate it so much words can't express!!! Best Regards, Jamie P.S for the calender drop down on the main page, i'm using 'microsoft time & date picker 6.0) - pop ups on this site - same file, better website. 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. Hello I'm quite experienced Excel user.
I've never come across this problem but tinkering in every conceivable way within Excel settings and the solution has eluded me. I have added a worksheet created elsewhere (it is a form I need printing, with the data coming from 2 sheets I have created from scratch) which has pre formatted cells for Date and Client Name etc.
When I try to reference the cell in this added sheet from my 2 sheets, instead of the result, it always displays the formula, not the result. I have tried doing it from one of my sheets to reference to this new, and that displays the result and not formula. I can't imagine why it's doing this and I've never seen it happen before. Formatting cells, giving cells names rather than the usually adequate of reference to the Cell Number doesn't change things. I wonder if I've picked up some legacy protection from the original form but can't see anywhere in the tools etc that's obvious. There's about 50+ cells that need referencing and I got to get this done for work.
Please help me. This is my first need to post on a Excel Forum as I've always found help or answers from other peeps or internet but this one is making me scratch my head big time. 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. Hi there, I have a piece of code called ConvertDates that formats data contained on 6 worksheets.
The 6 data sheets all contain a data connection to a website of foreign exchange tables. What I want is for my code to execute as soon as the data connection refresh has finished. When I use the statement Code: ActiveWorkbook.RefreshAll Application.Run 'Project1.xlsm!ConvertDates' The code executes the macro whilst the refresh is still happening, thereby screwing up my results. I don't really want to use a timed wait, because the refresh speed is going to vary from user to user. Is there some way I can tell excel to wait till the refresh has finished and then execute the code? Any help would be hugely appreciated.
![Excel For Mac Lossing Data In Worksheets Excel For Mac Lossing Data In Worksheets](/uploads/1/2/5/6/125626254/377995010.png)
I'm trying to use conditional formatting to highlight phone calls that came in between certain hours. The call times are in the custom format h:mm, although it could easily be changed to an Excel time format. I'm using Excel 2002.
I want the cell to have a different fill color if it falls within particular time frames. Example: If the call came in between 22:00 and 23:59 color is light green. If the call came in between 23:59 and 08:00 the color is yellow. Example spreadsheet is attached. Thanks in advance. 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 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! Hi all, I hope you can help me with what I would like to do. I've searched and searched and not come up with anything yet!! I have one sheet which is my 'data' sheet with a number of columns, one of which is a date which may be repeated.
I then want to use another sheet with two cells where two dates can be entered and a button which allows you to copy the rows of data from the data sheet which have dates between the two specified originally. The list in the data sheet may not be in date order although I could update a macro to do this for me if needed. I would also like to do it so that if 'ALL' is typed in the date fields, it pulls over ALL the data. (Or something similar) Any help you can give would be much appreciated. Cheers, Kevin.