+ Reply to Thread
Results 1 to 2 of 2

Chart/ pivot table issue

  1. #1
    Registered User
    Join Date
    06-03-2013
    Location
    US
    MS-Off Ver
    Excel 2016
    Posts
    41

    Chart/ pivot table issue

    I am trying to create a visual of how many items are processed per day per person. every times i try to chart with or with out pivots it either does not work or only grabs part of the data. any suggestions?

    end result. each person will have there own chart on what they sold and how many.

    i am new to pivots and graphs

    data to work with:
    Capture.JPG

  2. #2
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Chart/ pivot table issue

    Hi Airedale360,

    The problem appears to be the way your data is structured!

    The Processor column needs a Helper Column - the Total column is really irrelevant for the Pivot Table.

    Assuming column A is empty, use this formula: =IF(B2="",A1,B2) and copy down (assuming you start with row 2). This will ensure that you do
    not have blanks for Sally, Jane Joe and Tony. Name this column whatever you like, but use THIS column in your Pivot Table instead of the Processor column.

    This should solve your problem.

    I hope this helps, please let me know!

    Regards,

    David


    - Please click on the *Add Reputation button at the bottom of helpful responses.

    Please mark your thread as SOLVED:
    - Click Thread Tools above your first post, select "Mark your thread as Solved".

    Last edited by David A Coop; 07-28-2016 at 03:30 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot Table & Chart with Excel VBA - issue on mAcro
    By bsguna in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-14-2016, 06:30 AM
  2. Automating Pivot table and pivot chart creation if data table names unknown
    By Vegiepie2016 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-04-2016, 11:52 AM
  3. Pivot table issue, I'm not able to capture new data, when table is updated
    By johnnyq113 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-26-2015, 05:01 PM
  4. Pivot Chart Issue
    By Bob@Sun in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-11-2010, 04:24 PM
  5. Pivot Chart Issue
    By Bob@Sun in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-05-2010, 04:21 PM
  6. Pivot Chart issue
    By AndreLaplume in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-22-2006, 09:18 PM
  7. [SOLVED] Pivot chart issue
    By James in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 09-13-2005, 11:05 AM

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