(Solved) – Plotting a multiple line graph in excel

(solved)-–-plotting-a-multiple-line-graph-in-excel

Suppose I have two columns containing two different variables in an excel worksheet. Is there a way to determine the frequency and percentage that satisfies a certain defined condition? For example in the image below, I want to find the frequency and percentage of Jeep (Mode) that have a distance of <5 then the frequency and percentage of Jeep that have a distance of 2-5.

excel

I want to make a graph similar to this with a y-axis of Percentage within distance category and an x-axis of Distance but I don’t know what are the steps.

graph

Leave a Reply

Your email address will not be published. Required fields are marked *