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.


  • You can't do it. What about a pivot table? – Máté Juhász Oct 28 '16 at 10:23
  • I'm happy to use any kind of chart that looks like my example if you can help? – Davy Oct 28 '16 at 10:34

You can do this-but not directly. Excel cannot plot "letters" in a scatter (xy) chart. However, it is easy to get around this limitation by assigning a numeric value to each letter/non-numeric value you want plotted.

So, in you example, add a column and fill it with values where A=1, B=2, C=3, D=4 and then use the numeric value for your Y (vertical) values.

Your chart would then match your example:


|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.