Add an unrelated label to a chart with a stacked bar and scatter plot graph

John Steel

New member
Joined
Aug 16, 2014
Messages
7
Reaction score
0
Points
0
I have a chart displaying a stacked horizontal bar graph to display a range of data with another series plotted as a scatter plot graph to identify the average within that range. I'd like to add a label to the left of each bar identifying the (unrelated data) number of data points (units) represented by each bar. Below is a picture of the chart, a picture of the chart with an example of how I'd like the label to be inserted and a link to the excel.
Graph pic.JPG Graph pic2.png
View attachment Chart excel.xlsm

The labels I'd like to attach are for the number of units located in cells D14:J14.

I've previously tried to identify the average in each stacked bar by adding a series with a small value where the average is and formatting its border a different color and thicker line but the next series (above the average) partially covers it up which is why I went with the scatter plot to show the average (plus I like the diamond marker better).

This is a difficult problem to describe so if anyone can take the time to look into the attached pics and excel and provide some suggestions would be greatly appreciated.

Thanks
 
Back
Top