Forum Discussion
jzeidler_1208
Apr 18, 2022Copper Contributor
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 defi...
- Apr 18, 2022
You can edit the series and specify the x-values there:
Result:
See the attached version.
HansVogelaar
Apr 18, 2022MVP
Could you attach a sample workbook, or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
jzeidler_1208
Apr 18, 2022Copper Contributor
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=taavqaxkqgk02az2mve26mtb5
Thank you!
https://www.dropbox.com/scl/fi/usjssjx6mmdkc7lfnzfwi/SAMPLE-GINI-FILE.xlsx?dl=0&rlkey=taavqaxkqgk02az2mve26mtb5
- HansVogelaarApr 18, 2022MVP
You can edit the series and specify the x-values there:
Result:
See the attached version.
- jzeidler_1208Apr 18, 2022Copper Contributor