How would you graph this information?

Hi,

you could create something like a buble matrix chart. As this is not a native visual, you might use the charticulator from the visual store. It is a very convenient and funny chart to create. I would go by having rows as Employee (1-7) and the positions (1-9). The frequency would define the bubble size. If you hover on one dot, you would get a tooltip, which you can also configure.

Else, create a matrix using same as above and use conditional formatting for coloring (as heatmap chart).

Regards,

Oktay

Did I answer your question? Then please mark my post as the solution.

If I helped you, click on the Thumbs Up to give Kudos.