Solved

Excel 2013 chart

Posted on 2013-11-10
4
212 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 80

Expert Comment

by:byundt
Comment Utility
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
Comment Utility
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 80

Accepted Solution

by:
byundt earned 500 total points
Comment Utility
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 80

Assisted Solution

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

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

762 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now