I want to create a chart with one x axis but multiple y axis points.
E.G. i receive excel spreadsheets for processses that our software runs. i would like to chart these results to analyze.
i have 4 columns of data. running time, start time, status, computer name
i want one column, start time, to be my x axis
i want the remaining columns to be the y axis points.
so i would like to chart each instance the process is running on the x axis and then group the y axis points together for the given time on the x axis. therefore allowing me to see trends and patterns.
so lets say i notice that their are multiple high values for the running time. the process to awhile to complete. i would like a chart that lets me quickly compare the other y axis values to see if there are patterns.
maybe there is a better way and i am open to suggestions but that is the result i am looking for.
Start Free Trial