Announcement

Collapse
No announcement yet.

Topic 31: Step-by-Step Guide to Creating a Pie Chart

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Topic 31: Step-by-Step Guide to Creating a Pie Chart

    Create a worksheet as follow as we will use it to demonstrate the steps to create a pie chart in Excel 2007:





    We can see that WindSports Sales are broken apart into categories. Vertically, in Column A, we can see that WindSport has categorized the sales according to the products that they sell: boomerangs, kites and toys. Horizontally, in Row 2, we can see that WindSport has categorized the sales according to the sales channels that they use for selling: In Store, Web Site and Mail Order. In addition, they have listed totals for each category and an overall total in the lower-right corner.

    For our first Chart we would like to show how each product total contributes to the overall total. This means that we are comparing three "parts" (boomerangs, kites, toys) to the overall total to see what proportion or percentage that each contributes to the whole.

    Anytime you have this situation (comparing parts to the overall total), a
    Pie chart type is an excellent choice.

    Now Totally FREE* SAP Online Training with 6000+ Real Time Screen Shots @ www.wikinewforum.com

    SAP HR/HCM, FICO, MM, SD, PP, PM, PS, CRM…

    DEMO CLICK HERE

    Example SAP HR - Special Topics apart from general topics:

    * Payroll & Time Schema's
    * Payroll & Time PCR's (Personal Calculation Rules)
    * Rates of Pay
    * Factoring/Pro-ration
    * Wage type Valuation
    * Time Quota's & Time Types
    * Time Evaluation
    * Absence Valuation
    * Compensation, Benefits, Performance Appraisal, e-Recruitments
    * Employee Self Service (ESS) & Manager Self Service (MSS)

    * CATS - Cross Application Time Sheets
    * Integration with FICO & other Modules and more and more....list will not stop
    * Totally End-to-End implementation Process with 6000+ Real Time Screen shots


    Join us and take Complete FREE SAP HR Training @ www.wikinewforum.com

    Thanks & Regards
    Wikipedia New Forum
    www.wikinewforum.com


    *REGISTER NOW (FREE)

  • #2
    To create and customize a pie chart

    1. Highlight the range A3:A5, then hold the Ctrl key, and select the second range E3:E5 (you are selecting two ranges of cells that are not adjacent to each other).

    2. From the Insert Tab, in the Charts group, point to the Pie chart icon.


    Now Totally FREE* SAP Online Training with 6000+ Real Time Screen Shots @ www.wikinewforum.com

    SAP HR/HCM, FICO, MM, SD, PP, PM, PS, CRM…

    DEMO CLICK HERE

    Example SAP HR - Special Topics apart from general topics:

    * Payroll & Time Schema's
    * Payroll & Time PCR's (Personal Calculation Rules)
    * Rates of Pay
    * Factoring/Pro-ration
    * Wage type Valuation
    * Time Quota's & Time Types
    * Time Evaluation
    * Absence Valuation
    * Compensation, Benefits, Performance Appraisal, e-Recruitments
    * Employee Self Service (ESS) & Manager Self Service (MSS)

    * CATS - Cross Application Time Sheets
    * Integration with FICO & other Modules and more and more....list will not stop
    * Totally End-to-End implementation Process with 6000+ Real Time Screen shots


    Join us and take Complete FREE SAP HR Training @ www.wikinewforum.com

    Thanks & Regards
    Wikipedia New Forum
    www.wikinewforum.com


    *REGISTER NOW (FREE)

    Comment


    • #3
      3. Click on the Pie chart icon and then point to the first option. As you can see, Excel gives you a description of what the chart should be used for. As you learn how to make charts, you can read these as you are trying to decide which chart is best for your message.

      Now Totally FREE* SAP Online Training with 6000+ Real Time Screen Shots @ www.wikinewforum.com

      SAP HR/HCM, FICO, MM, SD, PP, PM, PS, CRM…

      DEMO CLICK HERE

      Example SAP HR - Special Topics apart from general topics:

      * Payroll & Time Schema's
      * Payroll & Time PCR's (Personal Calculation Rules)
      * Rates of Pay
      * Factoring/Pro-ration
      * Wage type Valuation
      * Time Quota's & Time Types
      * Time Evaluation
      * Absence Valuation
      * Compensation, Benefits, Performance Appraisal, e-Recruitments
      * Employee Self Service (ESS) & Manager Self Service (MSS)

      * CATS - Cross Application Time Sheets
      * Integration with FICO & other Modules and more and more....list will not stop
      * Totally End-to-End implementation Process with 6000+ Real Time Screen shots


      Join us and take Complete FREE SAP HR Training @ www.wikinewforum.com

      Thanks & Regards
      Wikipedia New Forum
      www.wikinewforum.com


      *REGISTER NOW (FREE)

      Comment


      • #4
        4. Click on this first option to create your Pie chart. You can see that it placed a pie chart on top of the worksheet and opened the three contextual tabs for charts.

        Now Totally FREE* SAP Online Training with 6000+ Real Time Screen Shots @ www.wikinewforum.com

        SAP HR/HCM, FICO, MM, SD, PP, PM, PS, CRM…

        DEMO CLICK HERE

        Example SAP HR - Special Topics apart from general topics:

        * Payroll & Time Schema's
        * Payroll & Time PCR's (Personal Calculation Rules)
        * Rates of Pay
        * Factoring/Pro-ration
        * Wage type Valuation
        * Time Quota's & Time Types
        * Time Evaluation
        * Absence Valuation
        * Compensation, Benefits, Performance Appraisal, e-Recruitments
        * Employee Self Service (ESS) & Manager Self Service (MSS)

        * CATS - Cross Application Time Sheets
        * Integration with FICO & other Modules and more and more....list will not stop
        * Totally End-to-End implementation Process with 6000+ Real Time Screen shots


        Join us and take Complete FREE SAP HR Training @ www.wikinewforum.com

        Thanks & Regards
        Wikipedia New Forum
        www.wikinewforum.com


        *REGISTER NOW (FREE)

        Comment


        • #5
          5. To change the size of the chart, hold the Shift key and point to the upper left corner of the chart and when you see a diagonally pointing black arrow, click and drag inward. You should change the size to about the same size as seen in figure below:


          Now Totally FREE* SAP Online Training with 6000+ Real Time Screen Shots @ www.wikinewforum.com

          SAP HR/HCM, FICO, MM, SD, PP, PM, PS, CRM…

          DEMO CLICK HERE

          Example SAP HR - Special Topics apart from general topics:

          * Payroll & Time Schema's
          * Payroll & Time PCR's (Personal Calculation Rules)
          * Rates of Pay
          * Factoring/Pro-ration
          * Wage type Valuation
          * Time Quota's & Time Types
          * Time Evaluation
          * Absence Valuation
          * Compensation, Benefits, Performance Appraisal, e-Recruitments
          * Employee Self Service (ESS) & Manager Self Service (MSS)

          * CATS - Cross Application Time Sheets
          * Integration with FICO & other Modules and more and more....list will not stop
          * Totally End-to-End implementation Process with 6000+ Real Time Screen shots


          Join us and take Complete FREE SAP HR Training @ www.wikinewforum.com

          Thanks & Regards
          Wikipedia New Forum
          www.wikinewforum.com


          *REGISTER NOW (FREE)

          Comment


          • #6
            6. Click on the Quick Layout icon on the Chart Tools Design tab and point to the "Layout 1" option.

            Now Totally FREE* SAP Online Training with 6000+ Real Time Screen Shots @ www.wikinewforum.com

            SAP HR/HCM, FICO, MM, SD, PP, PM, PS, CRM…

            DEMO CLICK HERE

            Example SAP HR - Special Topics apart from general topics:

            * Payroll & Time Schema's
            * Payroll & Time PCR's (Personal Calculation Rules)
            * Rates of Pay
            * Factoring/Pro-ration
            * Wage type Valuation
            * Time Quota's & Time Types
            * Time Evaluation
            * Absence Valuation
            * Compensation, Benefits, Performance Appraisal, e-Recruitments
            * Employee Self Service (ESS) & Manager Self Service (MSS)

            * CATS - Cross Application Time Sheets
            * Integration with FICO & other Modules and more and more....list will not stop
            * Totally End-to-End implementation Process with 6000+ Real Time Screen shots


            Join us and take Complete FREE SAP HR Training @ www.wikinewforum.com

            Thanks & Regards
            Wikipedia New Forum
            www.wikinewforum.com


            *REGISTER NOW (FREE)

            Comment


            • #7
              7. You should see that the Quick Layout added a Chart Title, and the category names with percentages that convey how much each part contributes to the whole.

              Now Totally FREE* SAP Online Training with 6000+ Real Time Screen Shots @ www.wikinewforum.com

              SAP HR/HCM, FICO, MM, SD, PP, PM, PS, CRM…

              DEMO CLICK HERE

              Example SAP HR - Special Topics apart from general topics:

              * Payroll & Time Schema's
              * Payroll & Time PCR's (Personal Calculation Rules)
              * Rates of Pay
              * Factoring/Pro-ration
              * Wage type Valuation
              * Time Quota's & Time Types
              * Time Evaluation
              * Absence Valuation
              * Compensation, Benefits, Performance Appraisal, e-Recruitments
              * Employee Self Service (ESS) & Manager Self Service (MSS)

              * CATS - Cross Application Time Sheets
              * Integration with FICO & other Modules and more and more....list will not stop
              * Totally End-to-End implementation Process with 6000+ Real Time Screen shots


              Join us and take Complete FREE SAP HR Training @ www.wikinewforum.com

              Thanks & Regards
              Wikipedia New Forum
              www.wikinewforum.com


              *REGISTER NOW (FREE)

              Comment


              • #8
                8. Click on the More icon in the Chart Styles group.


                9. After you click on the "See More Selections" arrow, choose "Style 10".

                Now Totally FREE* SAP Online Training with 6000+ Real Time Screen Shots @ www.wikinewforum.com

                SAP HR/HCM, FICO, MM, SD, PP, PM, PS, CRM…

                DEMO CLICK HERE

                Example SAP HR - Special Topics apart from general topics:

                * Payroll & Time Schema's
                * Payroll & Time PCR's (Personal Calculation Rules)
                * Rates of Pay
                * Factoring/Pro-ration
                * Wage type Valuation
                * Time Quota's & Time Types
                * Time Evaluation
                * Absence Valuation
                * Compensation, Benefits, Performance Appraisal, e-Recruitments
                * Employee Self Service (ESS) & Manager Self Service (MSS)

                * CATS - Cross Application Time Sheets
                * Integration with FICO & other Modules and more and more....list will not stop
                * Totally End-to-End implementation Process with 6000+ Real Time Screen shots


                Join us and take Complete FREE SAP HR Training @ www.wikinewforum.com

                Thanks & Regards
                Wikipedia New Forum
                www.wikinewforum.com


                *REGISTER NOW (FREE)

                Comment


                • #9
                  10. After clicking on Style 10 you should see this:


                  11. Now we need to change the Chart Title. Click once on the Chart Title, then click a second time so that an I-beam cursor is flashing in the Chart Title.

                  Now Totally FREE* SAP Online Training with 6000+ Real Time Screen Shots @ www.wikinewforum.com

                  SAP HR/HCM, FICO, MM, SD, PP, PM, PS, CRM…

                  DEMO CLICK HERE

                  Example SAP HR - Special Topics apart from general topics:

                  * Payroll & Time Schema's
                  * Payroll & Time PCR's (Personal Calculation Rules)
                  * Rates of Pay
                  * Factoring/Pro-ration
                  * Wage type Valuation
                  * Time Quota's & Time Types
                  * Time Evaluation
                  * Absence Valuation
                  * Compensation, Benefits, Performance Appraisal, e-Recruitments
                  * Employee Self Service (ESS) & Manager Self Service (MSS)

                  * CATS - Cross Application Time Sheets
                  * Integration with FICO & other Modules and more and more....list will not stop
                  * Totally End-to-End implementation Process with 6000+ Real Time Screen shots


                  Join us and take Complete FREE SAP HR Training @ www.wikinewforum.com

                  Thanks & Regards
                  Wikipedia New Forum
                  www.wikinewforum.com


                  *REGISTER NOW (FREE)

                  Comment


                  • #10
                    12. Press Ctrl + A (keyboard shortcut for Select All).



                    13. Type "Summer Sales" and then click on the outer edge of the Chart to register the "Summer Sales" title.

                    Now Totally FREE* SAP Online Training with 6000+ Real Time Screen Shots @ www.wikinewforum.com

                    SAP HR/HCM, FICO, MM, SD, PP, PM, PS, CRM…

                    DEMO CLICK HERE

                    Example SAP HR - Special Topics apart from general topics:

                    * Payroll & Time Schema's
                    * Payroll & Time PCR's (Personal Calculation Rules)
                    * Rates of Pay
                    * Factoring/Pro-ration
                    * Wage type Valuation
                    * Time Quota's & Time Types
                    * Time Evaluation
                    * Absence Valuation
                    * Compensation, Benefits, Performance Appraisal, e-Recruitments
                    * Employee Self Service (ESS) & Manager Self Service (MSS)

                    * CATS - Cross Application Time Sheets
                    * Integration with FICO & other Modules and more and more....list will not stop
                    * Totally End-to-End implementation Process with 6000+ Real Time Screen shots


                    Join us and take Complete FREE SAP HR Training @ www.wikinewforum.com

                    Thanks & Regards
                    Wikipedia New Forum
                    www.wikinewforum.com


                    *REGISTER NOW (FREE)

                    Comment


                    • #11
                      14. To change the size of the chart, hold the Shift key and point to the upper left corner of the chart and when you see a diagonally pointing black arrow, click and drag outward. You should change the size to about the same size as seen in figure below:

                      Now Totally FREE* SAP Online Training with 6000+ Real Time Screen Shots @ www.wikinewforum.com

                      SAP HR/HCM, FICO, MM, SD, PP, PM, PS, CRM…

                      DEMO CLICK HERE

                      Example SAP HR - Special Topics apart from general topics:

                      * Payroll & Time Schema's
                      * Payroll & Time PCR's (Personal Calculation Rules)
                      * Rates of Pay
                      * Factoring/Pro-ration
                      * Wage type Valuation
                      * Time Quota's & Time Types
                      * Time Evaluation
                      * Absence Valuation
                      * Compensation, Benefits, Performance Appraisal, e-Recruitments
                      * Employee Self Service (ESS) & Manager Self Service (MSS)

                      * CATS - Cross Application Time Sheets
                      * Integration with FICO & other Modules and more and more....list will not stop
                      * Totally End-to-End implementation Process with 6000+ Real Time Screen shots


                      Join us and take Complete FREE SAP HR Training @ www.wikinewforum.com

                      Thanks & Regards
                      Wikipedia New Forum
                      www.wikinewforum.com


                      *REGISTER NOW (FREE)

                      Comment


                      • #12
                        15. To move that chart to below the Table, press and hold the Ctrl key and click on the chart (to selects it). Then click and drag your Pie chart. Then press Ctrl + F1 key to hide the Ribbons.


                        16. You can see that we have created an appropriate chart that shows how much each product contributed to the overall total sales. We can clearly see that the Toy products contribution the smallest amount to the overall total as compared to the other two products.
                        Now Totally FREE* SAP Online Training with 6000+ Real Time Screen Shots @ www.wikinewforum.com

                        SAP HR/HCM, FICO, MM, SD, PP, PM, PS, CRM…

                        DEMO CLICK HERE

                        Example SAP HR - Special Topics apart from general topics:

                        * Payroll & Time Schema's
                        * Payroll & Time PCR's (Personal Calculation Rules)
                        * Rates of Pay
                        * Factoring/Pro-ration
                        * Wage type Valuation
                        * Time Quota's & Time Types
                        * Time Evaluation
                        * Absence Valuation
                        * Compensation, Benefits, Performance Appraisal, e-Recruitments
                        * Employee Self Service (ESS) & Manager Self Service (MSS)

                        * CATS - Cross Application Time Sheets
                        * Integration with FICO & other Modules and more and more....list will not stop
                        * Totally End-to-End implementation Process with 6000+ Real Time Screen shots


                        Join us and take Complete FREE SAP HR Training @ www.wikinewforum.com

                        Thanks & Regards
                        Wikipedia New Forum
                        www.wikinewforum.com


                        *REGISTER NOW (FREE)

                        Comment


                        • #13
                          Hi

                          "Now 5000 Real-time Screen shots with two country payrolls (Your Choice) with Real-time Blueprint" waiting for you in World's Best SAP Training.>>
                          > >
                          Demo: Click Here
                          > >
                          MS-Office Free online Training with screenshots: Click Here
                          >>
                          > >

                          Online Training (Any time you can log-in)
                          WITH 5000 REAL-TIME SCREEN SHOTS

                          Presenting By World's No.1 Site Wikipedia

                          Timings: Any time you can open and can take training, Support: 24/7

                          We called as Special training because:
                          • Real-time Employees from Top MNC's will teach & answers your queries everyday.
                          • Real-time Scenarios
                          • Real-time System screenshots step by step configuration total 5000+ screenshots
                          • With two country payrolls (You can choice according your Location) and real-time Business Blueprint.
                          • Post training support like Resume building & Interview tips with exact requirement, we will provide top companies HR email ID's and every day Hot vacancy list.

                          > >

                          Special Topics apart from general topics -
                          which no one dare to teach>>
                          > >
                          • Payroll & Time Schema's
                          • Payroll & Time PCR's (Personal Calculation Rules)
                          • Rates of Pay
                          • Factoring/Pro-ration
                          • Wage type Valuation
                          • Absence type, Absence Quota's, Absence Valuation
                          • Time Evaluation
                          • Compensation, Benefits, Performance Appraisal
                          • Employee Self Service (ESS) & Manager Self Service (MSS)
                          • Integration with FICO & other Modules.....and more

                          > >

                          Totally End-to-End implementation with 5000+ Real-time Screenshots.

                          > >
                          Training Process:
                          Every day we will release topics which contain screenshots, you can go through any time (New option: You can Download Now) and trainers will be online 24/7 you can ask questions.

                          Duration:
                          45 days

                          Fee: ONLY $30

                          Pay Now though PayPal securely processes payments for Wikinewforum.com.

                          To Pay Click Here (You can finish paying in a few clicks)

                          Closing Note: We cover Total 5000 Real-time Screenshots with end-to-end implementation. No other training program can dare like us.

                          Demo: Click Here
                          > >
                          Thanks & Regards
                          Wikipedia New Forum
                          www.wikinewforum.com


                          Register now and access full info of - Career Tips, Breakings News, Film & TV News, Stocks Alerts, Food Lovers...And more @ www.wikinewforum.com>>
                          > >
                          Best of 2009 – Click Here>>
                          > >
                          Online MS Office (2003 & 2007) Training – Click Here
                          .


                          New TV Shows 2016: Colors, Star Plus, Sony, Zee, Sun, LifeOK

                          Best of YEAR 2015 (Click Here)

                          MUST SEE TOP Photos of the DAY

                          Download 6000+ SAP Real-time Screen shots & Documents



                          Comment

                          Unconfigured Static HTML Module

                          Collapse

                          Static HTML Module Content

                          Unconfigured Ad Widget

                          Collapse

                          Announcement

                          Collapse
                          No announcement yet.
                          Working...
                          X