I have absolutely no Excel ability and would appreciate if someone could tell me how to create a particular chart.
I have created some data where I have rows for items with a text description and columns for 1 to 7. I would like to plot on a chart only when one of the cells within the matrix has a value.
There is nothing numeric about this data.
An example of what I would like is this:
Item A x x Item B x x x Item C x x Item D x x x 1 2 3 4 5 6 7
I tried using a scatter chart but I got very strange results with numeric values.