Creating multi-line graphs

I have the following columns and data; how do I create a multi line graph so that each line is for each category.

Column A       Column B

2013-06-08    blue
2013-06-09    red
2013-06-09    blue
2013-06-10    green
...


I want a line graph to see a trend over time.  What I think is making it difficult here is that there are duplicate dates and items in column B.   If you think it would be better, I can run a query so that Column B values are all the same.
dorianitAsked:
Who is Participating?
 
Gašper KamenšekConnect With a Mentor Excel MVPCommented:
What re the values you are trying to graph...

Here I just made up some numbers, but it would go something like in the sample below

Line-Charts.xlsx
0
 
Patrick MatthewsCommented:
What is that you are trying to graph?
0
 
dorianitAuthor Commented:
I'm trying to graph blue, red, and green over time.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.