Hi, I was able to create a chart using a single series but spent nights trying to create a multi-series chart with no good result. If anyone can help me with this it would be of great help.
Here are my tables.
2 SQL tables:
Engineers & Disks
ENGINEERS
- eng_id
- first_name
- last_name
DISKS
- job_no
- model_no
- status (value of either Complete of Fail)
What I would like to do is create a query that would display total number of Engineer's Complete and Fail job.
probably would look like this: (I only edited the image so you'll understand what i want).
If its gonna help I also have posted the code for single series chart.
Many Thanks foryour help.