(In Access you can import Excel Worksheets or Named Ranges in as a Linked Table.) At we have created a good alternative for MS Query to work especially with SQL Queries against Excel tables. It is a lot easier to use rather than MS Query and works really well if you just need to create and run SQL - no VBA, no complex manipulations with MS Query...With this tool you can create any SQL query against tables in Excel workbook(s) using embedded SQL editor and run it immediately with the option to put result on a new or any existing worksheet.
That said, there are multiple ways to accomplish what you are trying to do.
In Excel, like Reuben says, the formulas that will probably work the best are .
In both cases, you match on a unique row and it returns the value of the given column\row to the left\down from the found id.
To complete this task, you must do the following: In this task, you add programming code that creates the simple chart with a small amount of data and then adds data to the chart.
Note that the procedures in this topic work with a Power Point 2010 presentation.
So check the "System Tables" in the "Query Wizard -- Choose Columns" dialog's options when you create the query will work round.