Multiple sets of data onto one graph

**erikw48** · 12-15-2014, 04:51 PM

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** · 12-15-2014, 05:02 PM

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

**MrShorty** · 12-15-2014, 06:12 PM

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:

Date range -- SSR CP% -- SSR secure % -- PUSR CP% -- PUSR secure % -- DSR CP% -- DSR secure%
11/17-11/21 -- 1 -- 1 -- .92 -- .79 -- .93 -- .93
and so on

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