Excel Graph

Occasional Contributor

How can I make Excel recognize text as a result in a Graph?


When I try to create a graph any of the cells that have text as a result do not show up in the graph

6 Replies


Do you mean like this or what?


@Sergei Baklan 


Column H is linked to the results in my other sheet - the results do not come out in the graph because they are text.


In column H you have texts, it doesn't matter you enter it manually, returned by formulae or by link. Text is text. Which kind of result do you expect building chart on texts?

The text result, The results are text not numbers, I want a graph to show the result as they are "words"