Skip navigation

Create a lesson Graph

356 Views 3 Replies Latest reply: Jun 10, 2012 9:23 PM by Barry RSS
Souad H Level 1 Level 1 (95 points)
Currently Being Moderated
Jun 10, 2012 1:38 PM

HI all,

I need to track my study's on MacBook Pro OSX 10.7.4 .....

So I'm looking for a way to do so using Numbers versionn 2.1 (436)  (or Pages, Keynote)

I need to create something similar to this *pic

Screen Shot 2012-06-10 at 3.25.31 PM.png

*Purple color done, white need to be finished.

How to create such a thing?

Thanks in advance.

MacBook Pro, Mac OS X (10.7)
  • Wayne Contello Level 6 Level 6 (12,790 points)
    Currently Being Moderated
    Jun 10, 2012 2:04 PM (in response to Souad H)

    You can achive this be creating a stacked bar graph where the segments show a percentage and you make several other changes to the default settings:

     

    Screen Shot 2012-06-10 at 3.52.44 PM.png

     

     

     

     

    Set up the Lessons table as shown above.  Then make a new 2x2 table where the first column is a header (I called this table "Lessons Summary"):

     

    Now enter the formulas as follows:

    Screen Shot 2012-06-10 at 3.54.24 PM.png

     

    B1=COUNTIF(Lessons::B2:B20, "=TRUE")

    E2=COUNTA(Lessons::A2:A20)-B1

     

     

    To make the graph select A1 through B2:

    Screen Shot 2012-06-10 at 3.56.28 PM.png

     

    Then select the stacked, horizontal, bar chart from the Charts Menu in the tool bar:

    Screen Shot 2012-06-10 at 3.57.52 PM.png

     

    Now double click the left segment (in my example the Blue segment) of the bar chart and change the Fill color:

    Screen Shot 2012-06-10 at 4.00.02 PM.png

     

     

    Now change the fill color of the other segment (to white).  I have the change the font color when changing the segment color to make the text readable.

     

    Now change the chart so it show "%" instead of values by selecting the chart, then then opening the Charts Inspector:

    Screen Shot 2012-06-10 at 4.02.41 PM.png

    Then unselect all of the other check boxes in the "Value Axis (X)" menu as you don't want gridlines, tick marks, etc.  Do the same for the "Category Axis (Y)".

     

    Now select the chart and change the background fill color to "grey" so the white segment shows up

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Jun 10, 2012 9:23 PM (in response to Souad H)

    HI,

     

    There are no connections 'from' the Lessons table. It's simply a record of which lessons you've completed.

     

    The two formulas:

     

    =COUNTIF(Lessons::B2:B20, "=TRUE")

    =COUNTA(Lessons::A2:A20)-B1

     

    count two things:

     

    =COUNTIF(Lessons::B2:B20, "=TRUE"

     

    goes in cell B2 of the Lesson Summary table. This formula counts the number of checked boxes in rows 2 to 20 of column B of the Lessons table. (In Wayne's example, three boxes are checked. so the formula returns the value 3.)

     

     

    =COUNTA(Lessons::A2:A20)-B1

     

    goes in cell B3 of the Lesson Summary table. This formula counts the number of lessons entered in rows 2 to 20 or column A of the Lessons table (19) then subtracts the count of completed lessons in cell B1 of its own table (3) to determine the number of lessons not yet completed (16) and returns that value to its cell (B3)

     

    Note that for the formula to work you must either name the main table "Lesons", or replace "Lessons" in both formulas with the name of your main table.

     

    The  numbers in the small table, Lesson Summary, will change as you  complete further lessons and check them off using the checkboxes on the main table, Lessons.

     

    Those changes will be shown in the cart, which will automatically calculate the percentage completed and still pending from the calculated values in the table Lesson Summary.

     

    Regards,

    Barry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.