I am trying to draw a chart in Excel using the following data:
------------
| x | y |
------------
| 1 | 1.5 |
------------
| 2 | 3.0 |
------------
| 4 | 5.9 |
------------
| 8 | 11.0 |
------------
Currently, if I use a line chart, then the data points on the x-axis will be spaced equally and the lines will not correctly show the trend of y where improvement is linear at first but slows down afterwards:
If I use a scatter plot, then I can achieve correct spacing and correct lines showing the trend of y, but the data points on the x-axis will not just include the valid data points but rather, the whole range of 1 to 8 which is not what I want:
The way I want the chart is to look is for the x-axis to only include the data points under the "x" column of the table, like the line chart, but space the points in a linear fashion so that the space between 2 and 4 will be double 1 and 2 and so on, like the scatter chart. Something like this (created by editing the scatter chart in Photoshop):
Is there any way to achieve this in Excel?
P.S. Even though I am a VBA novice, a VBA solution is also acceptable.