+ Reply to Thread
Results 1 to 2 of 2

Charts and entries with identical fields

  1. #1
    Registered User
    Join Date
    06-03-2010
    Location
    Urbana, IL
    MS-Off Ver
    Excel 2007
    Posts
    7

    Question Charts and entries with identical fields

    I have just completed a spreadsheet of orders of publications from my office, with quantity of the publication ordered and the requester of the publication speficied. Often there are multiple orders from the same requester across a period of months, and I would like to create a simple chart showing who orders the most- but when I do this, I do get most of what I want, but multiple instances of the same requester at different dates are not grouped together like I want them to be. In my bar chart I get multiple bars for groups with more than one entry and what I need is for it to be one bar for each group with the total number of publications ordered.

    So my question is, instead of 5 seperate entries with the requester as "group A" and different quantities and dates for each entry, how can I get Excel to merge identical requester entries and add up the quantity of publications ordered so I just get one data point out of it?

    Thanks much in advance folks!

  2. #2
    Registered User
    Join Date
    06-01-2010
    Location
    Arlington, VA
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Charts and entries with identical fields

    Assuming you have a unique identifier of some sort for each requester, you can easily create a chart like this using a Pivot Table/Pivot Chart. When you're setting up the Pivot Table/Pivot Chart, go into the layout before clicking Finish. When you drag the field into the data box, you can just go into the field's options, go into advanced, and say you want to use "count" rather than "sum" (assuming it defaulted to sum). The process should be able the same if you're creating a Pivot Chart.

    If you attach your spreadsheet or a dummy version, you could probably get some specific tips.
    Last edited by JeffCPA; 06-03-2010 at 03:26 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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