Results 1 to 3 of 3

How to change/customize the value of x-axis on an excel scatterplot

Threaded View

  1. #1
    Registered User
    Join Date
    06-03-2013
    Location
    NYC
    MS-Off Ver
    Excel 2008 Mac
    Posts
    4

    How to change/customize the value of x-axis on an excel scatterplot

    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!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1