How do I graph text data in Excel?
Select Range to Create a Graph from Workbook DataHighlight the cells that contain the data you want to use in your graph by clicking and dragging your mouse across the cells.Your cell range will now be highlighted in gray.Once the text is highlighted you can select a graph (which Excel refers to as chart).