Question: Using excel and below data : Create a graph that shows the % of Payment Type for Store Symbol ABI. Handling Clerk Region AP Store
Using excel and below data : Create a graph that shows the % of Payment Type for Store Symbol ABI.
| Handling Clerk Region | AP | Store Symbol | Payment Type | Payment($) | Reference number | Reference Type |
| Region 6 Houston | 04 | NBM | LP Loss Pay | 346 | 221390323 | (A) System Check |
| Region 6 Houston | 05 | MED | LP Loss Pay | 1,621.26 | 221390365 | (A) System Check |
| Region 11 Tampa | 01 | NBM | LP Loss Pay | 169.24 | 221390859 | (A) System Check |
| Region 6 Houston | 06 | ABI | LP Loss Pay | 500 | 221401645 | (A) System Check |
| Indiana Main Office | 01 | MED | LP Loss Pay | 1,000.00 | 221369415 | (A) System Check |
| Region 6 Houston | 03 | ABI | LP Loss Pay | 50,001.00 | 221403327 | (A) System Check |
| Region 6 Houston | 01 | NBM | LP Loss Pay | 150 | 221392159 | (A) System Check |
| Region 6 Houston | 01 | NBW | LP Loss Pay | 390.4 | 221404796 | (A) System Check |
| Region 6 Houston | 09 | ABI | LP Loss Pay | 205 | 221404861 | (A) System Check |
| Region 6 Houston | 03 | ABI | FP Final Pay | 19,501.00 | 221669709 | (A) System Check |
| Region 6 Houston | 02 | MED | LP Loss Pay | 150 | 221391410 | (A) System Check |
| Region 6 Houston | 04 | ABI | LP Loss Pay | 14,526.17 | 221403216 | (A) System Check |
| Region 6 Houston | 05 | ABI | LP Loss Pay | 500 | W00620260 | (D) Customer Choice Epay |
| Region 6 Houston | 02 | ABI | FP Final Pay | 776 | 221407561 | (A) System Check |
| Region 6 Houston | 04 | ABI | LP Loss Pay | 2,820.00 | 221405092 | (A) System Check |
| Region 6 Houston | 04 | ABI | LP Loss Pay | 635 | 212158498 | (Z) Correction |
| Region 6 Houston | 10 | ABI | FP Final Pay | 400 | 221403766 | (A) System Check |
| Indiana Main Office | 07 | ABI | LP Loss Pay | 811 | 221404206 | (A) System Check |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
