Creating a chart

New Contributor

This I'm sure is super simple, and I feel super stupid. I'm attempting to create a simple chart in Excel from just 5 sets of data (Excel file attached). I want it to look like this, just updated. I am having a heckuva time getting the chart to work. Come on, what's the secret?



2 Replies
best response confirmed by JonPeltier (MVP)

@Ted_W1855 No real secrets, but the last four numbers in your list are texts. How did you enter them? Just retype them and it will work as desired.

Screenshot 2021-04-25 at 06.53.17.png

@Riny_van_EekelenDuh! Too easy. Now I feel really stupid. Thanks for your prompt reply.