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
Medium Priority
222 Views
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
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
• 3

LVL 81

Expert Comment

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

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

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

byundt earned 2000 total points
ID: 39637535
Here is the checkbox to make the values in the y-axis in reverse order:
0

Featured Post

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, …
Suggested Courses
Course of the Month8 days, 9 hours left to enroll