Question about Microsoft Office Standard for PC
When we create a Pivot chart using Pivot Wizard it creats a OLAP query which contains the path for the table data. If we move the table data into some other place then the pivot chart is not get opened. Then I have manually change the path to get the chart. Is there any solution to automate the path changes or to inform the user about the changes in the location of the table data.
Highlight the entire pivot table and name it as a range. Then in the formula, replace the reference to the table addresses with the range name. Then wherever you move the table (move, not cut and paste) it will automatically gather the right data. Thanks for rating FixYa!
Posted on Apr 22, 2008
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Apr 22, 2013 | Microsoft Office Computers & Internet
Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.
Click on the "Insert" tab at the top of the document.
Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.
Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.
Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.
Hit the "OK" button at the bottom of the Create Table dialog box to create your table.
Mar 18, 2011 | Computers & Internet
Jan 08, 2011 | Microsoft Office Access 2003 (077-02871)...
May 07, 2009 | Microsoft Excel for PC
Feb 27, 2009 | Microsoft Excel for PC
Feb 17, 2009 | Microsoft EXCEL 2004 for Mac
Jun 03, 2008 | Microsoft Computers & Internet
May 29, 2008 | Computers & Internet
Feb 23, 2008 | Microsoft Office Standard for PC
135 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: