I have two X-Y scatter plots that I need to compare and therefore, the x-axis (and y-axis) values need to be the same. I need three graphs, one each of the two regions and one combining all of it together. I've included the excel file for review and if someone could tell me how to achieve this, I would greatly appreciate as I anticipate this becoming a frequent problem. In the file, the graphs in question can be found on the last three tabs to the right. One tab is for Veneto, one for Lombardia, and the other for both combined.
Ideally I need the x-axis value to go from 60% to 110% and the y-axis from 0% to 14% but because my data involve numbers to the second decimal point, I'd also like to know if there is a way to change the icons used in the legend to a much smaller bullet point type of symbol. Some of my measurements are 0.02 or 0.04 or 0.08 and on the graph, these appear all lumped together at 0%. While seemingly insignificant, I need the graph to visually differentiate from these as much as possible. Thanks!
Bookmarks