+ Reply to Thread
Results 1 to 4 of 4

2nd Pie Chart showing % of sales within 1 pivot

  1. #1
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    Office 365
    Posts
    471

    2nd Pie Chart showing % of sales within 1 pivot

    Hello All

    Please see attached

    I would like a 2nd graph showing (Pie Chart) showing % of sales for each customer

    I would like this on 1 Tab so they both update as more data is fed into the sheet

    Thanks for your time
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,423

    Re: 2nd Pie Chart showing % of sales within 1 pivot

    If I understand correctly then one simple way to accomplish the goal is to produce a second pivot table from the source data.
    The second pivot table utilizes Customer in the Rows field and Total Cost in the Values field.
    The Week and Month slicers are connected to both pivot tables/charts.
    Note that this is modeled on the Pivot2 sheet.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    Office 365
    Posts
    471

    Re: 2nd Pie Chart showing % of sales within 1 pivot

    How do you connect the Slicer to both Pivots

    Also, When i change the font size it keeps automatically changes it back

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,423

    Re: 2nd Pie Chart showing % of sales within 1 pivot

    Here is a tutorial about connecting slicers to multiple pivot tables: https://contexturesblog.com/archives...-2010-slicers/
    The following tutorial may help with font size pertaining to data labels: https://peltiertech.com/?s=set+defau...ze+data+labels
    You might also search the Peltiertech.com site to find more information.
    Alternatively, you might mark this thread as 'Solved' and open a new thread on the topic of data label size so that it will attract some of the contributors that knowledgeable on that specific subject.
    Let us know if you have any questions.

+ 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. [SOLVED] Pivot Chart Not Showing All Data
    By Gtrtim112 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-13-2019, 01:07 PM
  2. Showing Variance in a Pivot Chart
    By BryceVBA in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-23-2018, 12:08 PM
  3. Showing Sales Trend In Pivot Table
    By Statz in forum Excel General
    Replies: 3
    Last Post: 10-13-2017, 09:58 AM
  4. Pivot Chart not showing right values
    By droman in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-14-2017, 01:18 PM
  5. Showing Grand totals in a pivot chart
    By i82 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-13-2016, 03:17 AM
  6. Help adding sales to pivot chart
    By B_Jarbs in forum Excel General
    Replies: 1
    Last Post: 04-02-2016, 05:21 PM
  7. [SOLVED] Pivot chart filtered showing subtotal
    By Eemmai in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-05-2012, 05:57 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