Results 1 to 5 of 5

1) Use Table to create a Pivot Table 2) Why it's meaningful information 3) Bar graph

Threaded View

  1. #1
    Registered User
    Join Date
    12-30-2016
    Location
    Toronto
    MS-Off Ver
    Excel 16
    Posts
    2

    Question 1) Use Table to create a Pivot Table 2) Why it's meaningful information 3) Bar graph

    Hello! I am doing an "assignment" for a potential job opening. I have figured out most the problems, but a little confused on this one:

    "Use Table 7 to create a Pivot Table that shows the most meaningful information. Please write a brief description outlining why you chose to highlight the specific information."

    The instructions are within the attached file. I'm assuming that 'month' and 'category code' aren't meaningful, but would love another opinion. I know how to create a pivot table but again not really sure which information is relevant.

    The images below are a snapshot of the worksheet.

    Once again thanks for the help!

    Screen Shot 2016-12-30 at 9.18.15 PM.png
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 07-29-2016, 04:30 PM
  2. Replies: 2
    Last Post: 09-02-2014, 06:21 PM
  3. [SOLVED] Copy and paste formula outside pivot table using information from table
    By batjl9 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-01-2014, 07:10 AM
  4. Unable to create meaningful relationship in Power Pivot
    By Melvinrobb in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-08-2014, 10:28 AM
  5. Heat Mapping by row for a table of information (or a pivot table)
    By jacebailes in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-06-2013, 06:22 PM
  6. Replies: 0
    Last Post: 04-20-2010, 01:34 PM
  7. [SOLVED] How do you create a complicated pivot table graph?
    By Natalia Kozyura in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-06-2005, 10:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1