+ Reply to Thread
Results 1 to 12 of 12

Donut Pie Chart- V-Lookup

  1. #1
    Forum Contributor
    Join Date
    10-06-2015
    Location
    london
    MS-Off Ver
    2013
    Posts
    149

    Donut Pie Chart- V-Lookup

    Hello

    I need to create a doughnut pie chart whereby when a contract is chosen from the drop down list, the doughnut chart is updated automatically.

    As there are several vehicles for each contract, it would need to pick up all machines for that contract and then calculate and update.

    Please advise suggestions.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Donut Pie Chart- V-Lookup

    What do you want to plot on the doughnut chart? I am assuming the source data is on the efficiency page, columns G:L. How are the percentages calculated? Winchester has two percentages. I don't think you want to average them. One could be 0 for 1 and the other could be 100 for 100, so the real result would be ~99% not 50%.

  3. #3
    Forum Contributor
    Join Date
    10-06-2015
    Location
    london
    MS-Off Ver
    2013
    Posts
    149

    Re: Donut Pie Chart- V-Lookup

    Hello

    I want it to calculate the average score for each machine.

  4. #4
    Forum Contributor
    Join Date
    10-06-2015
    Location
    london
    MS-Off Ver
    2013
    Posts
    149

    Re: Donut Pie Chart- V-Lookup

    can I send you another file? i think maybe that will help you more

  5. #5
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Donut Pie Chart- V-Lookup

    Average of what? Hours?

  6. #6
    Forum Contributor
    Join Date
    10-06-2015
    Location
    london
    MS-Off Ver
    2013
    Posts
    149

    Re: Donut Pie Chart- V-Lookup

    yes thats correct

  7. #7
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Donut Pie Chart- V-Lookup

    OK, one more question. To which dropdown box are you referring?

  8. #8
    Forum Contributor
    Join Date
    10-06-2015
    Location
    london
    MS-Off Ver
    2013
    Posts
    149

    Re: Donut Pie Chart- V-Lookup

    B5 in sheet1

  9. #9
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Donut Pie Chart- V-Lookup

    I think what you might want is a pivot chart made off the data. Let me know if this is what you want.
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    10-06-2015
    Location
    london
    MS-Off Ver
    2013
    Posts
    149

    Re: Donut Pie Chart- V-Lookup

    I have looked at this and think it may not be what I am looking for. I will email another sheet so you can look at this. Ideally what I want is doughnut efficiency chart done for all machines

  11. #11
    Forum Contributor
    Join Date
    10-06-2015
    Location
    london
    MS-Off Ver
    2013
    Posts
    149

    Re: Donut Pie Chart- V-Lookup

    i am not able to upload on here as file is too big

  12. #12
    Forum Contributor
    Join Date
    10-06-2015
    Location
    london
    MS-Off Ver
    2013
    Posts
    149

    Re: Donut Pie Chart- V-Lookup

    what i want is a doughnut pie chart as shown on sheet one which calculates overall figures using data in efficiency report. And when the person selects a contract from b5 all the graphs are updated

+ 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. Donut Chart - Aligning Series Centrally
    By TobyJarvis in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-10-2015, 08:37 AM
  2. Donut Chart with 2 data sets - Legend does not work
    By jasonj427 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-14-2015, 04:56 AM
  3. [SOLVED] Gauge chart the needle is behind the donut area
    By SMILE in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-25-2015, 06:35 AM
  4. [SOLVED] Recreate this donut chart?
    By IronCladRooster in forum Excel General
    Replies: 2
    Last Post: 12-16-2014, 03:44 PM
  5. Clock Chart (overlapping donut style)
    By reynoldsohio in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-28-2013, 07:19 AM
  6. how to make a Donut Chart
    By mushman1 in forum Excel General
    Replies: 4
    Last Post: 06-22-2010, 04:54 PM
  7. Conditional Formating-a Donut/Speedometer chart.
    By Tempus in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-12-2006, 03:50 PM

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