Creating a Pie Chart
Ddlalicous1
pivot_chart__1.xlsDemographics
| Client's Name | Address | City | State | Zip | Phone Number | Date of Birth | Age | Medications | Social Security Number |
| SHARON THOMAS | 1413 S CALIFORNIA | COMPTON | CA | 90221 | 310-631-1988 | 02/28/99 | 17 | Adderall | 424-26-4789 |
| DON WALKER | 15215 BROOKSHIRE | DOWNEY | CA | 90242 | 562-775-3125 | 12/15/79 | 37 | Paxil | 56-48-2323 |
| DANIELLE SMITH | 26 SUNSHINE STREET | MORENO VALLEY | CA | 92551 | 951-887-8765 | 09/11/60 | 56 | Adderall | 345-67-8901 |
| MILES HAVEN | 2666 E 55TH WAY | LONG BEACH | CA | 90805 | 562-258-6569 | 08/25/69 | 47 | Ritalin | 456-78-9012 |
| THOMAS JOHNSON | 312 ACKERFIELD LANE | WILMINGTON | CA | 90744 | 310-867-4759 | 04/03/80 | 37 | Xanax | 567-89-0123 |
| SHAYLA JOHNS | 552 CHERRYCREEK RD | SAN PEDRO | CA | 90731 | 562-323-1455 | 03/23/83 | 34 | Adderall | 678-90-1234 |
| TERRI SHAWN | 61 BANNER DRIVE | PARAMOUNT | CA | 90723 | 562-685-2323 | 08/02/98 | 18 | Ibuprofen | 789-01-2345 |
| DOLORES GOMEZ | 9128 TRAVIS DR | NORWALK | CA | 90651 | 310-9641352 | 11/24/78 | 38 | Xanax | 890-12-3456 |
| Ted Jackson | 3101 E ARTESIA | PERRIS | CA | 92570 | 951-635-7412 | 04/24/97 | 20 | Adderall | 901-23-4567 |
| FRED JACKSON | 1614 CHESTNUT AVE | CORONA | CA | 92880 | 951-242-8759 | 12/01/84 | 32 | Ibuprofen | 423-94-0387 |
| Adderall | 4 | Adderall | |||||||
| Paxil | 1 | ||||||||
| Ritalin | 1 | ||||||||
| Xanax | 2 | ||||||||
| Ibuprofen | 2 |
&CDATABASE
Demographics
Medication
Number of clients
Bar Graph of Number of Clients of Specific Medicines
Bar graph
Bar graph
| Adderall |
| Paxil |
| Ritalin |
| Xanax |
| Ibuprofen |
Medication
Number of clients
Bar Graph of Number of Clients of Specific Medicines
4
1
1
2
2
Encounters
| Client's Name | Therapist Seen | Service Provided | Date of Service | Hours of Service | Fee per hour | Amount Due | Amount Paid | Balance |
| DON WALKER | Frank Mullins | Medication | 01/12/16 | 1 | $ 50.00 | $ 50.00 | $ 40.00 | $ 10.00 |
| DON WALKER | Frank Mullins | Medication | 02/22/16 | 1 | $ 50.00 | $ 50.00 | $ 35.00 | $ 15.00 |
| DOLORES GOMEZ | Jodie Blackwell | Individual | 03/16/16 | 1.25 | $ 80.00 | $ 100.00 | $ 80.00 | $ 20.00 |
| SHARON THOMAS | Frank Mullins | Family | 04/10/16 | 2 | $ 100.00 | $ 200.00 | $ 150.00 | $ 50.00 |
| SHARON THOMAS | Frank Mullins | Family | 05/22/16 | 2 | $ 100.00 | $ 200.00 | $ 100.00 | $ 100.00 |
| SHARON THOMAS | Frank Mullins | Family | 05/30/16 | 2 | $ 100.00 | $ 200.00 | $ 140.00 | $ 60.00 |
| SHARON THOMAS | Frank Mullins | Family | 07/06/16 | 2 | $ 100.00 | $ 200.00 | $ 175.00 | $ 25.00 |
| DOLORES GOMEZ | Jodie Blackwell | Individual | 07/15/16 | 1.25 | $ 80.00 | $ 100.00 | $ 90.00 | $ 10.00 |
| DON WALKER | Frank Mullins | Medication | 08/23/16 | 1 | $ 50.00 | $ 50.00 | $ 48.00 | $ 2.00 |
| DON WALKER | Frank Mullins | Medication | 09/09/16 | 1 | $ 50.00 | $ 50.00 | $ 43.00 | $ 7.00 |
| DOLORES GOMEZ | Jodie Blackwell | Individual | 11/15/16 | 1.25 | $ 80.00 | $ 100.00 | $ 98.00 | $ 2.00 |
| DON WALKER | Frank Mullins | Medication | 02/14/17 | 1 | $ 50.00 | $ 50.00 | $ 50.00 | $ - 0 |
| DOLORES GOMEZ | Jodie Blackwell | Individual | 02/25/17 | 1.25 | $ 80.00 | $ 100.00 | $ 89.00 | $ 11.00 |
| DOLORES GOMEZ | Jodie Blackwell | Individual | 03/29/17 | 1.25 | $ 80.00 | $ 100.00 | $ 80.00 | $ 20.00 |
| SHARON THOMAS | Frank Mullins | Family | 04/07/17 | 2 | $ 100.00 | $ 200.00 | $ 180.00 | $ 20.00 |
