For the most part, an overweight rating indicates less about the literal meaning of giving a stock higher weight than a given benchmark. Instead, it's typically used as Wall Street jargon to indicate a positive attitude about a particular stock.
To set an option to automatically refresh PivotTable data when you open your workbook, do the following: 1  Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon. 2  Click Analyze > Options. 3  In the PivotTable Options dialog box, on the Data tab, check the Refresh data when opening the file box.
Select all the data in your table. Select Insert/Pivot Table and create a Pivot Chart on a new sheet. You can sort the data in your pivot chart independent from your main table.I. In Excel 2010, I need to create a chart that shows my data in a descending order. However, my table that the data is taken from is in alphabetical and not numerical order.