Visualize cell value to a bar graph inserted into a cell

[StrawberryDreams]

I understand that sparklines can do something like this, but I think it needs a range instead of individual cell values, for it to work properly. Also not sure if sparklines can work with vertical merged cells.

The following picture show how I want a bar graph to represent the value and its column name within the cell (s) above itself. Can this be done ? You can see I just averaged the value amounts visually. Maybe find the MAX value of all the cells to base the highest peak to scale the rest of the lower values on ?

Basic data calculator test 9.6.xlsm
	F	G	H	I	J	K
1
2
3
4
5
6
7
8
9		10	4	2	3
10		A	B	C	D
11
Sheet5

 

[StrawberryDreams]

Maybe the only way is to create a full table bar chart, and size each column until its the same width as the cells, then physically drag the chart into the area and try and line it up, so it appears to be line up with the cell names. and values ?

 

[StrawberryDreams]

My Column Widths are 7, and I overlaid / dragged a bar chart with background fill and outline set to nothing, and made the width 7.85" wide which seemed to make the bars appear to fit within the cell guidelines. Maybe not perfect but appears to fit. Would like a perfect solution if one still can be done.