100 % bar graph (stacked side by side)

Hello

attached is my graph im working on.

there are two graphs.

1)one is a clustered side by side graph showing the $ dolar value

2)100% clustered side by side...where my target is my projected revenue aka 72800$

.....i believe its been done correctly, if one of your gurus can kindly have a look and let me know.

more importantly,
if someone can help me with the graph first (grey color), as i cant get the legend to show the person's name aka cell C9

also, for my second graoh (blue and red color....100% clustered), how can i get the value to show up? i would like the dollar value to show instead of the percentage?

can someone pls help me with this, been struggling for the past day +. thx you, much appreciated!!!

1. Use the source data or select data dialog to set the Series name to C9.
Although this is not actually correct as all the information is related to C9 and the variation in colour, which the legend is used to decode, is not client name.

2. You can use this free addin to link data labels to cells in order to display alternative information via the data labels.
http://www.appspro.com/Utilities/ChartLabeler.htm

I don't understand your chart so can not post example.

The legend reports the name of each different set of data in the chart.
You chart has 2 sets of data so the legend reports 2 entries.

If you only want 1 then select and delete the legend entry. But this will mean the legend is not correctly reporting the detail of the chart.

The legend should be used to identify the 2 different sets of columns in the chart.
Perhaps the Title is a better place to report the Client name as it applies to all of the chart and not just 1 data series.