Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

Excel 2013 chart

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
leblanc
Asked:
leblanc
  • 3
2 Solutions
 
byundtCommented:
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
 
leblancAccountingAuthor Commented:
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
 
byundtCommented:
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
 
byundtCommented:
Here is the checkbox to make the values in the y-axis in reverse order:
Y-axis "Values in reverse order"
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now