Excel Graph

Copper 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

@Gamz180127 

Do you mean like this or what?

image.png

@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.

@Gamz180127 

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"