Hey Guys,
I have attached a file with my raw data, i am trying to create a graph that will show a count of "Complete", "Not Complete" and "N/A".
So im assuming a bar graph would work best...because, within the "Complete", it needs to be broken down into 3 colours representing the status: "Red", "Green" and "Amber". If it is Blank, then it will count as "Not Complete".
Obviously the "Not Complete" & and "N/A" will be one solid line each.
I am not sure how to do this after many attempts, I am not even sure if the Bar graph will be best representation.
Please have a look and let me know.
Thanks!
M
Bookmarks