Solved

Excel 2013 chart

Posted on 2013-11-10
4
218 Views
Last Modified: 2013-11-25
Hello,

I have the following data:
Time availability: 100%, 70%, and 20%
Response time: 5 seconds, 40 seconds, and 60 seconds.

Is it possible to have some sort of chart that shows the relationship between those 2 data? I did the chart with 2 x-axis but they do not relate to each other (see attached). In other words, if you look at the chart and interpret it, you take the 100% (on the left x-axis) and it is aligned with 62 seconds (on the right x-axis). I am wondering if it is possible to represent with a chart or something else (other than the data table) to have 100% align with 5 seconds and so on. Thanks
chart.JPG
0
Comment
Question by:leblanc
  • 3
4 Comments
 
LVL 81

Expert Comment

by:byundt
ID: 39637247
I'm not understanding your difficulty. As the question is written, one would put availability on the X-axis and Response time on the Y axis (or vice-versa) of a scatter chart.
ResponseTime-vs-Availability-Cha.xlsx
0
 
LVL 1

Author Comment

by:leblanc
ID: 39637472
May be I did not explain it very well. What I'd like to have is two lines, one for the Time Availability and one for the Response Time on the same chart. The x-axis will be the Day throughout the year
As you can see from my chart, if you look at 100% (on the left y-axis), it is aligned with 62 seconds (on the right y-axis). I am wondering if it is possible to represent with a chart or something else to have 100% align with 5 seconds.
0
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 39637530
In Excel 2013, the trick is to use the values "in reverse order" on one of the y-axes.

If you furthermore want 5 seconds to line up exactly with 100%, then you also need to make sure that the minimum value on the normal order y-axis is 5 seconds and the maximum on the reverse order y-axis is 100%.
ResponseTime-vs-Availability-Cha.xlsx
0
 
LVL 81

Assisted Solution

by:byundt
byundt earned 500 total points
ID: 39637535
Here is the checkbox to make the values in the y-axis in reverse order:
Y-axis "Values in reverse order"
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question