After a few seconds, the PowerPivot window will open and display in a table (called Table1 or similar) your data from the Excel range. You can rename this table and you can use the functionality of ...

Try to use XY (Scatter), Bubble, or Stock as a PivotChart, and you’ll get an alert saying you cannot create it with pivot data. So, do you give up? Nope. Remember the post where I converted a ...