creating line graph with multiple lines

**elchenuk** · 03-31-2017, 07:59 AM

Hi, I have a table that looks a bit like the following:

date	Source	Amount
1/1/17	Source A	3
1/1/17	Source B	4
2/1/17	Source A	6
2/1/17	Source B	5

and so on...

I want to create a chart that will plot different lines (coloured) for each source across all the dates. How do I go about this?

thanks!
Eddy

**MrShorty** · 03-31-2017, 08:44 AM

I would use something like this "conditional formatting" example: http://peltiertech.com/conditional-f...-excel-charts/ Use functions (like the IF() function) to copy each "source" value into separate columns, then use those helper columns as the chart source data.