Question about Microsoft Office Standard for PC

1 Answer

Excel Pivot view

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.

 

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Legend:

    An expert who has written 200 answers of more than 400 characters.

  • Expert
  • 359 Answers

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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to invoke a ms.access using parser


To parse a Text field that contains two words separated by a comma, follow these steps:
  1. Open any existing database.
  2. Create a table with the following structure: Table: Parse2Words
    ------------------
    Field Name: Empl
    Data Type: Text
  3. View the Parse2Words table in Datasheet view and type the following three records in the Empl field: Smith, John
    Callahan, Laura
    Fuller, Andrew
  4. Create the following query based on the Parse2Words table: Query: QueryTest
    ------------------------------------------------------------------
    Field: FirstName: Right$([Empl],Len([Empl])- InStr(1,[Empl],",")-1)
    Show: True
    Field: LastName: Left$([Empl],InStr(1,[Empl],",")-1)
    Show: True

    NOTE: You can modify the QueryTest query to account for spaces between the two parts in the Empl field. For example, if the text in the Empl field is "Smith,John" without spaces, remove the -1 from the FirstName field expression.
  5. Run the query. Note that the QueryTest query separates the text in the Empl field into the two fields below: FirstName LastName
    --------------------
    John Smith
    Laura Callahan
    Andrew Fuller

Jan 08, 2011 | Microsoft Office Access 2003 (077-02871)...

1 Answer

CAN WE ENTER DATA IN TABLE THROUGH QUERY CALCULATION


Yes, you can add the resulting calculations to an existing query by using and update query, or you can create a completely new table with the results of the query in it by using a make-table query.

Oct 28, 2009 | Microsoft Office Access 2003 (077-02871)...

2 Answers

Count the number of open and closed order status per owner


My suggestion is to use a Pivot Table.  Follow these instructions:
Click on column A1 - then in the menu bar click DATA > Pivot Table and Pivot Chart Report.  

Click NEXT on step 1 of pivot table wizard.
For step two you will want to highlight all of the data on your sheet.  then click next.
Choose NEW WORKSHEET for step 3 of the pivot table wizard and click finish.
Once the Pivot Table sheet opens, drag the STATUS field into the top left corner of the pivot table view, where "drop column fields" and "drop row fields" meet.  Next drop another instance of the STATUS field into the "drop row fields here" column.  And lastly drop the OWNER field into the "drop column fields here" section.  You should now be viewing a report showing you exactly what you were looking for.
Regards,
Joe


May 07, 2009 | Microsoft Excel for PC

1 Answer

Creating a table in Ms-Access


Have you tried to name the table Tiny_tots? it might make it work. Sometimes programs are funny about letting you have spaces in the name.

Oct 04, 2008 | Microsoft Office Standard for PC

1 Answer

How we can create Forms & queries in access


For forms, open a data table in view mode, while there locate the forms setup wizard. For your first try just answer the questions the best you can for the wizard. When there are no more questions to answer wizard will create a form for you. From what you learn doing that you may get enough hints to make a form from scratch. Just keep in mind you always build a form from the fields in a table.
Now for the Query, start out the same way and use the wizard. Query to most folks means ask a question and get an answer. In access query is a way to present sub sets of data or ways to modify data in the fields of your tables.

Jun 03, 2008 | Microsoft Computers & Internet

1 Answer

Vb project


One of three ways:
1 make the table using vb creating a Bload screen.
2 using the visual data manager.
3 import a windows access or excel data base table.

Try the data wizard, easiest to use and U can program the program to manipulate the data in the tables.

May 29, 2008 | Computers & Internet

1 Answer

Data for excel chart


You need to create subtotals so that it looks like something like this:

Prod/units Amt. Level Total

xxxx 10.00 1
yyyy 20.00 1
30.00

dddd 40.00 2
ffff 30.00 2
70.00

etc.

To do this I would suggest using the Pivot Table feature of Excel. It is not too hard to use but you do have to know what you want and also have to be sure you are getting results as expected. Like any tool, it has to be used right. You can also use sub-total functions supplied in VBA as well in your cells.

If you want to avoid using VBA functions in cell and deal with ranges, etc., use the Pivot Table Wizard.

Some reading:
http://www.ehow.com/how_13020_pivot-table-wizard.html
http://www.microsoft.com/dynamics/using/excel_pivot_tables_collins.mspx
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

Also Google "Excel pivot table wizard" to get more.

Good luck!

Feb 23, 2008 | Microsoft Office Standard for PC

1 Answer

Unable to create chart in excel


Check the source data that it is using to create your chart (right-click choose SOURCE DATA). The result you're getting sounds as if it may not include all the data you want to chart. Generally should include at least two rows AND at least two columns.

Nov 16, 2007 | Computers & Internet

4 Answers

Running SQL queries on Excel


Another way to do it is to use the SQL Drill freeware Excel addin (http://www.sqldrill.com)
hth

Aug 14, 2007 | Microsoft Office 2003 Basic Edition...

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

135 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...