In the attached file I have to create a bar chart in cells.
The cells in question contain a number 0 to 1 which indicates the size of the bar.
Some of the bars have been inserted as samples.
If a cell has a 1 then the bar extends the entire width of the cell.
if the cell has a 0 or is blank then no bar
If the cell has a partial amount then the bar size shall be proportionately reduced with respect to the cell width.
- if the cell to the right is blank then the bar is left justified
- if the cell to the left is blank then the bar is right justified
- if both the cells to the left and right are blank then the bar is centred
- if none of the left and right cells are blank then the bar is left justified.
furthermore the color of the bars should be as per column BI.
I can use bars created one per cell but if it is not too much effort then it would be better to have one bar spanning multiple cells wherever the data is continuous.