I know that I can load bottom-loaded data, and then if I choose the column headers when creating a plot, Excel will automaticlaly plot newly added data and adjust the chart scales automatically.  However, it is more practical to use the bottom of the sheet for NOTES so is there a way to get Excel to exhibit this same behavior for top-loaded data?\n\nTHANKS!
203783
When you create a chart, do not specify the data range with a range of cells, use a dynamic range. The range will expand automatically when data is loaded, at the top or bottom. See the Source link for several examples.
393383
They claim to have interfaces to and from any popular FE analysis programme in the market, although Excel or ASCII is not on the list.\n\nHowever, some of the options are ASCII based, such as DXF and IGES.  From there, you'd be able to find another interface, or actually write one yourself, as Excel reads many formats, including ASCII.
538113
Yes they do.  Go to Format, then Cell, Click on the Allignment tab and put a check in the box next to "Wrap text".\n\nAfter you have entered your text, put your mouse at the line between the cell you are working in and the one above.  You will get 2 arrows (one pointing up and one point down) double click there and the cell height will expand automaticly.
417199
http://www.officerecovery.com/excel/\n\nTry here if the help in Excel doesn't help.\n\nRegards\n\nRob
150036
Can't do that in Excel. The best thing you can do is type your headings in row 1 in each column.
243687
You probably took some action that made the column width change (there are any number of ways this can happen).\n\nThe solution is (assuming you're using Excel or a similar spreadsheet) is to select the columns that have changed (click on the column letter and hold down the mouse button and drag across the top until all the columns you want to change have been highlighted).  Next, right click, select column width, then enter a vaule less than that shown (you can experiment with values until you get the width you want).  Finally, hit enter.
130058
find a better Statstic book, or use CHIDIST / CHIINV functions in MS-Excel. Or use this thing:\nhttp://www.georgetown.edu/faculty/ballc/webtools/web_chi.html\njust make sure it gives same numbers for lower df's as your table
343107
the easiest way would be to label your columns or rows at the top before you plot the graph.\n\neg. i have data in 2 columns. rename column 2 as concentration. rename column 3 as density. \n\nthe graph would be vs time. so I have a column 1 renamed as time.
76343
GETPIVOTDATA does get in the way...\n\nEither type the cell reference directly, or select another cell outside the table then click and drag it into the pivot table to the cell you want to refer to.  No other way round it I'm afraid!
253890
#1.  You are assuming that the active worksheet is the first one in the book .. if it's not, it will bomb ... see ActiveSheet property\n\n#2.  You are assuming that the macro/VBA is running in this book, but if the user has multiple workbooks open, this may not be the case ... see ActiveWorkbook object.  Better?  Select Workbooks by name (see Tag values independent of filenames)\n\n#3.  Font, color, bold are meaningless for a programming problem.  Omit them for future clarity in asking a question.  Less meaningless stuff we have to wade through.\n\n#4.  Cells(1,1) depends on where the active cell is, the user or your macro may be jumping to a different place than you think it is.  Has someone inserted a row or column ?\n\nI've been doing VBA for 15 years and I have no clue what you mean by "The server threw an exception" ... you mean what ?\n\nClues as to how to fix ... use named ranges and offsets.  Name a range (always relative to the range).  Offset from there.  Always select the correct window, workbook and sheet by name, not index value.  Omit needless code from your recorded macros such as "Transpose=False" ...\n\nStop recording macros and trying to make them work.  Recording is good to get you started, not for real code.\n\nAll in all, it's a very nice semi-adjusted recorded macro.\n\nI'm not dissin' on ya Partner !   ;-)\n\nThere are good habbits and there are bad.  Learn the good habbits and life will be a cake-walk.\n\nAlways define a marker cell ... typically the top/right corner of your range or table or whatever.\n\nAlways reference everything from that point.\n\nLock the worksheet to prevent users from inserting/deleting rows/columns.\n\nUsed named sheets ... not index values.  All one has to do is insert a sheet and you're hosed.\n\nSuspenders and a belt ... this is Visual Basic here ... anything can happen.\n\nHere's a useful link for you ... just understand that here, you're pretty much expected to know your stuff or be very, very concise and specific in your inquiries and responses ...\n\nhttp://www.tek-tips.com\n\nI would encourage you to look through the forums and judge for yourself before you post.\n\nGood luck.  If I can help you out, my contact info is in the Bio.  There is always more than one way to do things ... collect the best, chuck the rest !   ;-)
532262
in excel you would use formulas such as =a1*3 in each cell to make the effect work from a starting number.  In HTML, you would actually use an XML table and/or some kind of scripting such as vbscript or javascript.
320020
You could use conditional formatting on the cells where you are entering your data.  But you actually don't need to do conditional formatting, it's just that you can get smoother more interesting effects if you do.  An easier way might be a simple formula.\n\nIt sounds like you are entering data that uses Case numbers, but if you have already entered a case, you don't want to do it again.  Obviously you could just search the case number column to see if it already exists and if so, then skip entering it.  But a more automated way would be easier.\n\nThe essence of what you need to do is use a formula to tell you if what you just entered already exists in the rows above. (To use your example, does case 24 exist already in the rows above A27?)\n\nYou could insert a (temporary) column to the left of what you are typing in.  In that column you would enter a formula to count the number of instances where the case number you just entered already exists above.  Usually the result would be 1, sometimes 2.\n\nLets say you are on row 27 and your case numbers are in column B, and your counting column is column A.  Lets assume your data starts on row 2 at the top of the spreadsheet.  Your formula for cell A27 would be:\n=IF(COUNTIF($B$2:B27,B27)>1, "Exists Already!", "")\n\nNotice the $ signs in the Countif formula.  The formula range will adjust as appropriately as you copy it around.  You want to get this formula on every line next to every case number so that it can alert you if it seen there is more than once instance.\n\n(Actually the Data Validation mentioned below is a better solution because it will prohibit you from entering the data.  But it's all the same principle. Just more elegant because you don't need to insert a new column.)
446433
If have the same problem importanting my data.\nIn fact there are two problems, one is the separation between data columns, the other is the fact that in American notation for dates and numbers is different from the European one.\n\nIf you open a csv file  OpenOffice shows you a Text Import window.\nFirst you change the Separator options. In my case the Comma field is set, so I change it to semi-colon ; as my data are separated like that, but it might be that space or tab is the correct choice for your data.\n\nNow you have your data in correct columns.\n\nGo to the Fields lower on the pages. Each column is labelled Standard. Right clicking on the word Standard gives you various other options including several ones for the date, as well as the difference between American and European number format.\n\nIf you don't get OpenOffice to understand you, there is no other choice than to change the input file by hand or macro first.\n\nPS If a date does not contain the year, OpenOffice *always* assumes it is the present year. Therefore you have to change the date columns either by including the year explicitly, or in OpenOffice after import.\n\nPS2 I have everything automated with macros. After all it is an exercise one has to repeat often.
529893
That is a good question needs a GOOD answer.\nYou have some tools in Excel to do this.\nTry:\n1- View > Toolbars > Forms\nand draw the object you want (Use Checkbox and OptionBox will help you alot)\nRight click on each of these boxes and go to Properties > Control where you can select the way this control controls the action.\nYou can alos use ListBox or ComboBoxes.\n2- You may need some VBA macros to complete the job\n\nI can do alot of these for you, need you to send me more info here in Y! Answers and I can promise I will help\n\nEnjoy my profile, I am the VBAXLMan
43551
Microsoft Excel would do just fine to create charts for a small business - especially if you are only doing it for your employees. If you are doing charts to show potential investors, then investing in better chart creating software may make more sense. \n\nHowever, if you want improved charts, you can either get an additional plugin for your main chart software (whether you are using Excel or Corel or any other software); or redo the charts and make them look pretty with Adobe Illustrator. One plugin I like is CrystalGraphics (cost is $99), which has a product called Powerplug Charts that allow you to create more visually pleasing charts and graphs than what Excel can provide.
359600
There are far too many details missing from your question to give a good answer.  You don't indicate if you are talking daily, weekly, monthly, or intraday price/volume data.  If so, why not just download the historical data itself rather than keeping your own history?  Or whether you are possibly referring to fundamental data.  The answers can depend a lot on just what you are doing with the data.\n\nI'd suggest a visit to some Yahoo groups that deal with retrieving data from the Internet for use in EXCEL:\n\nhttp://tech.groups.yahoo.com/group/xltraders/\nhttp://finance.groups.yahoo.com/group/smf_addin/\n\nWithin the context of a discussion thread, where details like the above can be exchanged, you may get a better answer.  Also, the files areas of the two groups contain a number of tools and examples of getting financial data off the web.\n\nBTW -- the second group is one of mine.
508501
I know Excel inside & out...and I would love to help you, but I really cant understand what you are asking for.\n\nSo - you are trying to find the picture. OK. Pictures are handled as graphics on a different layer. They are not tied directly to cells or formulas. It should be clearly visible\n\nTry this: select all (Ctrl-A) go to the edit menu, select Clear > Formats. Now, in the format menu,  row > unhide, row > autofit, and Column > unhide, Column > autofit.\n\nThat should open up your entire worksheet. If something is there, you should see it.