+ Reply to Thread
Results 1 to 4 of 4

Help with pie chart formatting...?

  1. #1
    Registered User
    Join Date
    07-28-2013
    Location
    Nottingham
    MS-Off Ver
    Excel 2010
    Posts
    12

    Question Help with pie chart formatting...?

    Hi all, this may be a tad difficult to explain.

    Essentially i want to have a pie chart where there is a 1/4 filled in when a person has achieved 25% towards a certain level of training.

    So, if i was fully competent, my pie chart would be at 100% and hence fully coloured in. At 25%, it would be 25% coloured and the rest white or something along those lines.

    From this i would like to be able to have a drop down which says 25/50/75/100 % and this would automatically bring up the pie chart mentioned above.

    Is this possible?

    Cheers as always

    Simon

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

    Re: Help with pie chart formatting...?

    I think, based on the description in post #1, this should work. The data validation drop down is in A2, and the chart will appear to the right of the drop down. The formula in A3 is
    Please Login or Register  to view this content.
    To hide the chart again select A2 and press the delete key.
    Here is the file: Competency Pie Chart.xlsx
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    07-28-2013
    Location
    Nottingham
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Help with pie chart formatting...?

    Brilliant! Many thanks

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

    Re: Help with pie chart formatting...?

    You're welcome and thank you for the feedback. If you haven't already please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a good day.

+ 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 use formatting of a chart on another chart in Powerpoint
    By rammher2 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-30-2014, 06:41 AM
  2. [SOLVED] VBA Chart Formatting
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-14-2014, 02:48 AM
  3. Chart Formatting
    By dimitrz in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-01-2008, 06:40 AM
  4. Formatting a Chart
    By Rick_Stanich in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 09-16-2008, 11:49 AM
  5. Chart Formatting
    By pnwood in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-27-2005, 12:49 PM
  6. Replies: 0
    Last Post: 07-22-2005, 11:05 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