Advertisement

11.12.2007 at 02:59PM PST, ID: 22955879
[x]
Attachment Details

how to create a chart with multiple y axis categories

Asked by YankeeFan03 in Microsoft Excel Spreadsheet Software, Spreadsheet Software

Tags: , , , ,

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
 
Loading Advertisement...
 
[+][-]11.12.2007 at 06:33PM PST, ID: 20269163

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Excel Spreadsheet Software, Spreadsheet Software
Tags: excel, axis, multiple, y, chart
Sign Up Now!
Solution Provided By: macsek
Participating Experts: 4
Solution Grade: A
 
 
[+][-]11.12.2007 at 06:34PM PST, ID: 20269167

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.12.2007 at 07:17PM PST, ID: 20269287

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]11.12.2007 at 11:58PM PST, ID: 20270087

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]12.14.2007 at 11:31PM PST, ID: 20476476

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628