hi all,
is it possible to combine a dot-matrix style plot with a calculated field expressed as a percent number, one on top of the other?
the top row would show the visual count by the number of dots.
the bottom row would show the percentage of dots that are green, as a percentage.
having major pains getting this combination to show correctly, whenever I add anything to the Rows, the dot matrix would disappear.
any help or suggestions appreciated, thanks.
3 answers
hi Ken,
thanks for your response. my workbook + data is a little too large to share easily right now, but I appreciate the feedback. I am ditching the dot matrix in favor of a bar chart, no point in getting too fancy here. thanks.
