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.

6

1 Answer

I had explained the limitations in my answer.

Now I have understood that you want only scale to be appeared on the X-Axis.

In that case, dont select the Line Option but do asbelow :

1. Select the Data
2. Select the option Insert on the Top
3. Select SCATTER
4. Select 2nd Option : " With Smooth Line and Markers"

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy