+ Reply to Thread
Results 1 to 5 of 5

Pivot Charts to show Attach Ratios

  1. #1
    Registered User
    Join Date
    06-05-2020
    Location
    Pennsylvania
    MS-Off Ver
    365
    Posts
    11

    Pivot Charts to show Attach Ratios

    Hi everyone,
    So I’m working on a sales tracker and so far everything has been going pretty well (thanks to some help from this forum), But I’ve hit a wall. I have a Dashboard with a pivot bar chart in the center, a standard pivot table on the right, and on the left, I would like to have three pivot circle charts going down the side. Going across the bottom I have three slicers called “Quarter” “Period” and “Week” that I would like to have linked to all the pivot charts/tables on the dashboard (including the circle charts)

    I would like to have each circle chart show a different attach ratio (a sales rep was able to attach product Y when the customer bought product X). For example, In Q1 Period 1, week 1, 15 units of product X were sold and product Y was successfully attached to 8 of them, giving an attach rate of 53%. The next week (Q1, P1, W2) 30 units of product x were sold and 18 had product Y attached, giving an attach rate of 60% and for all of period 1 lets say the attach rate was 75%. I’ve made circle charts before, but from data that was from the same week. I’m not sure how I can show these attach ratios across multiple weeks, periods, and quarters and link everything up to the same slicer. Also, how could I easily calculate these ratios?

    I’ve attached a generic sample of my tracker to give a better idea of what I’m talking about
    Attached Files Attached Files
    Last edited by 45687354154896; 06-12-2020 at 09:46 PM.

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,102

    Re: Pivot Charts to show Attach Ratios

    Please repost your workbook with dummy data. There is no data to manipulate

  3. #3
    Registered User
    Join Date
    06-05-2020
    Location
    Pennsylvania
    MS-Off Ver
    365
    Posts
    11

    Re: Pivot Charts to show Attach Ratios

    Quote Originally Posted by maniacb View Post
    Please repost your workbook with dummy data. There is no data to manipulate
    Sorry, just re uploaded it.

    Thank you

  4. #4
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,102

    Re: Pivot Charts to show Attach Ratios

    I made an attempt at producing the graphs you outlined. I had to remove the No values to make the graphs make sense. Let us know if you have any further questions.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-05-2020
    Location
    Pennsylvania
    MS-Off Ver
    365
    Posts
    11

    Re: Pivot Charts to show Attach Ratios

    Quote Originally Posted by maniacb View Post
    I made an attempt at producing the graphs you outlined. I had to remove the No values to make the graphs make sense. Let us know if you have any further questions.
    Wasn't quite what I had in mind originally. I was only going to show the attach rates for the specific location as a whole. But I really like how you did it by sales rep. and the way you have your pivot tables set up helped me to to both, Thank you so much for your help!

+ 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. How can I show pivot table data split across two charts?
    By durna01 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-02-2018, 05:47 PM
  2. How to make userform show pivot charts
    By farrag in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2017, 07:40 AM
  3. Dynamic Pivot Charts: show data from last 6 periods only
    By robertgroen92 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2014, 10:58 AM
  4. Command Button to Show Hidden pivot charts
    By Chioma1975 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2013, 08:56 PM
  5. Defined format to show ratios.
    By all4excel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-26-2007, 12:56 PM
  6. [SOLVED] show results of two pivot charts
    By johnjmcdermott in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-06-2006, 08:50 AM
  7. create charts using concatenated ratios (e.g. 1:250, 1:325, 1:10)
    By Prof Jack in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-22-2005, 12:05 PM

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