Multiple sets of data onto one graph

[erikw48]

I am attempting to take the following tables and merge them all onto one line graph.. Is this possible?

Scheduling Success Rate
Date C&P % Secure %
11/17-11/21 100% 100%
11/24-11/28 100% 100%
12/1-12/5 100% 100%

P/U Success Rate
Date C&P % Secure %
11/17-11/21 92% 79%
11/24-11/28 85% 100%
12/1-12/5 81% 87%

Delivery Success Rate
Date C&P % Secure %
11/17-11/21 93% 93%
11/24-11/28 95% 70%
12/1-12/5 92% 73%

[erikw48]

If I am not making myself clear please let me know that I may assist in describing the request more clearly, thanks!

[MrShorty]

I find that a lot of charting questions really end up being about data layout in the spreadsheet. My first thought would be to arrange the data like this:

Please Login or Register  to view this content.

Select date range though DSR secure% columns --> insert line chart and the chart should come out correctly. Sometimes, Excel does not automatically recognize that the leftmost column should be the x/category axis data, so you may need to go into the "select data" dialog to clean up anything Excel doesn't interpret automatically. For specific instructions: https://support.office.com/en-us/art...rs=en-US&ad=US

[erikw48]

Thank you very much for your insight MrShorty!