Excel 2 scatter chart

[szaby]

Hello,

I have this problem.
I have a data range between 15-40.
This data range I have to reduce to 0-25.
Now I have to make a chart, scatter type and I need the values between 15-40 on the left side and the values between 0-25 on the right side. Can I make this somehow? Sorry if it is a stupid question or if you did not understand it.

Thanks.

 

[Andrew Poulsom]

Welcome to the Board.

Can't you just use a spare column to deduct 15 from your original numbers and plot both sets?

 

[szaby]

Hi

No, because it will be one under the another and I need the original values on the left and the new values on the right.

I tried with secondary axes but it didn't work out.

 

[Andrew Poulsom]

Please post a sample of your x and y values.

 

[szaby]

<table x:str="" style="border-collapse: collapse; width: 96pt;" border="0" cellpadding="0" cellspacing="0" width="128"><col style="width: 48pt;" span="2" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 48pt;" x:num="" align="right" height="17" width="64">34</td> <td style="width: 48pt;" x:num="" x:fmla="=A1-15" align="right" width="64">19</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">40.17</td> <td x:num="" x:fmla="=A2-15" align="right">25.17</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">27.5</td> <td x:num="" x:fmla="=A3-15" align="right">12.5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">26</td> <td x:num="" x:fmla="=A4-15" align="right">11</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">22.5</td> <td x:num="" x:fmla="=A5-15" align="right">7.5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">30</td> <td x:num="" x:fmla="=A6-15" align="right">15</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">26</td> <td x:num="" x:fmla="=A7-15" align="right">11</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">26</td> <td x:num="" x:fmla="=A8-15" align="right">11</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">33.33</td> <td x:num="" x:fmla="=A9-15" align="right">18.33</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">35</td> <td x:num="" x:fmla="=A10-15" align="right">20</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">40</td> <td x:num="" x:fmla="=A11-15" align="right">25</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">23</td> <td x:num="" x:fmla="=A12-15" align="right">8</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">37</td> <td x:num="" x:fmla="=A13-15" align="right">22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">25</td> <td x:num="" x:fmla="=A14-15" align="right">10</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">29</td> <td x:num="" x:fmla="=A15-15" align="right">14</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">30</td> <td x:num="" x:fmla="=A16-15" align="right">15</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">35</td> <td x:num="" x:fmla="=A17-15" align="right">20</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">27.5</td> <td x:num="" x:fmla="=A18-15" align="right">12.5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">30</td> <td x:num="" x:fmla="=A19-15" align="right">15</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">22.5</td> <td x:num="" x:fmla="=A20-15" align="right">7.5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">30</td> <td x:num="" x:fmla="=A21-15" align="right">15</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">25</td> <td x:num="" x:fmla="=A22-15" align="right">10</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">25</td> <td x:num="" x:fmla="=A23-15" align="right">10</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">25</td> <td x:num="" x:fmla="=A24-15" align="right">10</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">35</td> <td x:num="" x:fmla="=A25-15" align="right">20</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">28</td> <td x:num="" x:fmla="=A26-15" align="right">13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:num="" align="right" height="17">15</td> <td x:num="" x:fmla="=A27-15" align="right">0
</td> </tr> </tbody></table>

 

[Andrew Poulsom]

I assume they are y values (primary and secondary). What are the x values?

 

[szaby]

I need only Y values.

 

[szaby]

the x values would be 1-27 every dot representing a country

 

[Andrew Poulsom]

The plot this:

X1 Y1 X2 Y2
1 34 28 19
2 40.17 29 25.17
3 27.5 30 12.5
4 26 31 11
5 22.5 32 7.5
6 30 33 15
7 26 34 11
8 26 35 11
9 33.33 36 18.33
10 35 37 20
11 40 38 25
12 23 39 8
13 37 40 22
14 25 41 10
15 29 42 14
16 30 43 15
17 35 44 20
18 27.5 45 12.5
19 30 46 15
20 22.5 47 7.5
21 30 48 15
22 25 49 10
23 25 50 10
24 25 51 10
25 35 52 20
26 28 53 13
27 15 54 0

 

[szaby]

It's perfect thank you very much