is there a way to top load data in Excel and have Charts automatically update to include that data?
452391
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.
801228
I'm using Excel 2003. This solution should work for any recent version of Excel. \n\n1. Select the entire worksheet. You do this by either 1) clicking on the "select all" button, which is located between the labels for row 1 and column A (the very top left corner), or 2) press "Ctrl+A".\n\n2. On the top bar menu, choose Data/Sort. Choose the column on which you want to sort. (It almost doesn't matter for your purpose, but if you have a preferred order you might as well choose it now.) \n\nBe sure that the order is Ascending for now, even if you want it to be Descending in your final sort.\n\nIf your worksheet has a header row, you'll want to select the "Header row" radio button. If you choose this option, your header row (row labels) will stay at the top of your sort. If you choose "No header row," the header row labels will sort with the rest of your data.\n\n3. Click "OK." If the sort order is Ascending, your blank rows should be at the bottom of your list. If you had chosen to sort in Descending order, the blank rows would be at the top and you'd have to do a follow-up step of selecting the blank rows and deleting them. \n\nHope that helps.
162424
Insert --> Chart --> Pie\n\nHit next\n\nDrag your mouse across the data boxes in excel to specify how large it should be, then click on the Series tab, remove all those that are in that list box, click add, set Name equal to what the Pie Chart's name is, then enter all your values in between the ={}, with commas separating your entries. The 3rd step should be self-explanatory with titles and stuff, and from there you're set.
298247
Select your data. You have already entered your data, right?\n\nPull down the "insert" menu to "chart". Choose "line", choose the particular line graph you like best. Hold down the sample bar to see if the graph looks the way you expect it to. If you aren't making any changes, you can pretty much click "next" until you get a chance to click "finish".
462677
You can use Tables from MS Access or MS SQL Server Already loaded with Data
100785
You will need to write a program that acts as a screen scraper to pull the data you want. This will be hard if you are not a programmer.\n\nPossibly creating a link in your excell to get a spreadsheet of data for a stock would help you???\n\nhere is how to do it:\nPut each of these items into cells A6 through A20\nThis will allow you to change each item which are the stock symbol (lrw in this case) start and end dates.\nhttp:/ /ichart.finance. yahoo.com /table.csv?s=   (remove the spaces I did them so it could be read)\nlrw\n&a=\n0\n&b=\n1\n&c=\n1982\n&d=\n1\n&e=\n21\n&f=\n2006\n&g=d&ignore=.csv\n\nin cell A4 put:\n=CONCATENATE(A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20)\n\nand in cell A3 put"\n=hyperlink(A4,"Get Spreadsheet of historical data") \n\nnow click on the link and watch the chart load into a new spreadsheet.\n\nI know its not quite what you asked for but now you can graph and analyze the data for your favorite stocks.\n\nhttp://ichart.finance.yahoo.com/table.csv?s=bzh&a=0&b=1&c=1982&d=1&e=21&f=2006&g=d&ignore=.csv
406314
If you know Java, it is not hard to write code to do such task, it might be tedious though.\nIf you don't, Ms excel could handle the job too with reasonable time and effort.
953414
Pivot tables, then refresh the data when necessary. You may have the data automatically refresh upon entry. Rather than copy all of the EXCEL help files here, go there and type in "pivot tables".
431591
Use Microsoft Excel or a slide-rule
881302
Obviously depends on what you're using it for.  Some easy ones:\n\n* Formula updates - can do hours of manual calculations for you automatically in a second, and redo them if a base value changes.\n\n* Sorting - can be sorted on one or more columns, allowing you to easily rank data or create an alphabetical list.\n\n* Cut/Paste - changes/additions/deletions are all relatively painless, whereas on paper they might make you redo the entire thing.
906769
http://peltiertech.com/Excel/Charts/AddLine.html
904896
yeah its easy obviously when you know how.. i would suggest going into your help menu while using excel.. get the help page to guide you through pie charts.. its all in the x y axix
701765
create the chart and then right click on one of the bars...\n\nselect "format data series"\n\nclick on "Options" and make the gap width a larger number\n\ntada
342178
Try apache axis. You can use this tool for both client and server code.
1020376
Excel.  Even S & P computstat requires us to use excel to run the database.
112029
The microsoft downloads page has several for excel
855738
MS Excel has tons of great formulas.  Have you thought about using that.  Also, not sure what sort of database application you're using but formulas can usually be programmed into them.