I am trying to create a chart but i do not seem to be getting the result i am looking for. With the data below a client's name may show up multiple time in a data table with different periods listed. I am trying to get all data by client with the period on the horizontal axis and overservice on one hortizontal axis and revenue on the other horizontal axis. Ideally, i could pick the customer name from a dropdown menu and all the data related would populate the chart. Any help would be welcome?
<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>
Customer Name | Hours | Time Cost ) | Fiscal Period | Net Revenue | Overservice |
Client A | 342.75 | $ 46,038.75 | 201203 | $ 18,303.86 | 151.5% |
Client A | 240.25 | $ 31,006.25 | 201204 | $ 19,154.34 | 61.9% |
Client B | 234 | $ 42,125.00 | 201206 | $ 28,759.63 | 46.5% |
Client B | 190.75 | $ 34,568.75 | 201207 | $ 19,000.00 | 81.9% |
Client C | 341.25 | $ 56,156.25 | 201208 | $ 19,641.73 | 185.9% |
<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>