+ Reply to Thread
Results 1 to 2 of 2

Need graph with only totals with certain names

  1. #1
    Forum Contributor
    Join Date
    03-03-2011
    Location
    Ottawa, Ontario
    MS-Off Ver
    365
    Posts
    137

    Need graph with only totals with certain names

    I have a table with invoice no., names and totals on every row. I am looking for a way to produce a bar graph where I can compare invoices that have all names that I can select. For example.
    InvNo.1 - Bob - 10
    InvNo.1 - Fred - 15
    InvNo.2 - Bob - 5
    InvNo.2 - Fred - 10
    InvNo.2 - Tom - 20

    I was hoping to be able to select Bob, Fred and Tom and only return the totals where all 3 of those names appear for the same invoice. So it wouldn't return individual totals for InvNo.1 only InvNo.2. And if I selected Bob and Fred it would only return InvNo.1 and ignore the invoice with Tom. Is this possible? Would a pivot table be better suited for this and if so, how should I go about it. Thanks for any help.

  2. #2
    Valued Forum Contributor
    Join Date
    04-12-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, 2019, Office 365, Google Spreadhsheet
    Posts
    640

    Re: Need graph with only totals with certain names

    Yes, What I feel Pivot is the best option for this...Simply you can select the InvNo. in Row detail and then take the value in Value field. By this, you will get Total Invoice No. wise. Then simply you can create chart.

    You can also use slicer I believer this will perfectly fit here..

    Thanks,
    Anil
    Thanks,
    Anil Dhawan


    Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.

    Don't stop when you are tired. STOP when you are done!

+ 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. Creating graph with totals by zip code
    By forbes2000 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 07-14-2014, 09:24 PM
  2. [SOLVED] Stacked Bar Graph Totals
    By shiftyspina in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-05-2013, 04:39 AM
  3. problem with investment spreadsheet totals and graph
    By appleybridger in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-11-2012, 04:46 PM
  4. Totals in 3d bar graph don't add up correctly
    By jonfaris in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-18-2006, 02:35 PM
  5. graph totals
    By Mike in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 02-20-2005, 09:06 AM

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