Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Excel 2013 chart

Posted on 2013-11-10
4
Medium Priority
?
222 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

New style of hardware planning for Microsoft Exchange server.
If you're a modern-day technology professional, you may be wondering if certifications are really necessary. They are. Here's why.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

597 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