Forum Discussion
Scatterplots
Hello! I am using the EXCEL bivariate scatterplot function to create Lorenz curves and Gini coefficients using 16 data points. Both the X and Y axes are supposed to have a range from 0 to 1.0 as defined in the corresponding Excel data columns. While my Y axis data appears in the scatter plot with the correct 0 to 1.0 range, the X-axis data is consistently appearing with a range of 1 to 16, so mimicking the number of data entries rather than the correct numerical range the X-axis data values. This is obviously distorting my scatterplot results and creating an incorrect Lorenz curve. I tried adjusting the Axis Range for the X-axis, but that resulted in a grouping of all my data point at the 1.0 mark. Any ideas on how to correct this and get my X-axis on a 0 to 1.0 scale in tandem with the Y-axis? Many thanks for any help you can provide. JZ
You can edit the series and specify the x-values there:
Result:
See the attached version.
4 Replies
Could you attach a sample workbook, or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- Thank you, Hans. I have provided a DropBox link below which contains a sample Gini File. The two columns on the right of the Excel spreadsheet provide the data for my Y and X axes, and as I mentioned in my previous post, the problem I am having is with the X-axis data on the far right.
Thank you!
https://www.dropbox.com/scl/fi/usjssjx6mmdkc7lfnzfwi/SAMPLE-GINI-FILE.xlsx?dl=0&rlkey=taavqaxkqgk02az2mve26mtb5You can edit the series and specify the x-values there:
Result:
See the attached version.
