Excel 2007 : Excel 2007 - adding second set of data to graph

Hello All,
New to the forum and I ran a search on this but couldn't find anything relevant in 5 pages (may have searched the wrong keywords).

I'm trying to add a second set of data to the end of a bar graph. The graph consists of project names and percentage completed. At the end of every bar, I'd like to add a project end date.

I attached a copy of what I'd like to do. I tried a (bad) workaround and added a temporary graph to the right of the original graph with just the project end dates then moved the dates over to the original graph (shown in the image).

Any help would be greatly appreciated!

Depending on you chart you could use a dummy series on the secondary axis and set the dates as the category labels for the second axis.

Hard to tell without seeing the actual chart as you picture appears to have a multi series legend although the chart and data suggest only 1 series.

See example

Create a clustered bar chart based on the range A1:C5

Select the Dummy series and change to plot on secondary axis
Chart Tools > Design > Select Data
Select the dummy series and edit the Category Labels. Set the range to D2:D5

Add data labels to Dummy series
Change data labels to display categories