Boss wants a Graph for instructions to show progress

[ohmedic88]

I'm stuck with a request from my boss that wants a line graph for some Documents used for training. Right now I have the documents sitting in Folders Named Approved, Draft for Review, and Ready for Review

I'm wondering how to effectively display the data that will show progress. Currently, I have the Data situated Like this
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 673"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]SOP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 118"]
<tbody>[TR]
[TD="class: xl65, width: 118"]DRAFT for Review[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 116"]
<tbody>[TR]
[TD="width: 116"]Ready for Review[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Approved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Job aid 1[/TD]
[TD]July 17[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Job aid 2[/TD]
[TD]June 17
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Job aid 3[/TD]
[TD]June 17[/TD]
[TD]July 17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Job aid 4[/TD]
[TD]May 17[/TD]
[TD]June 17[/TD]
[TD]July 17[/TD]
[/TR]
</tbody>[/TABLE]

Any ideas on how I can arrange the data to show progress over months. I was thinking of having a Date due Column.

Any guidance or links to you tube videos would be helpful

Eric

 

[rilzniak]

Gantt or horizontal bar chart?

How to Create a Gantt Chart in Excel