+ Reply to Thread
Results 1 to 2 of 2

Issue with X axis values NOT graphing on Scatter graph and issue with Labels

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    Royal oak, mi
    MS-Off Ver
    Excel 2010
    Posts
    14

    Issue with X axis values NOT graphing on Scatter graph and issue with Labels

    Hello,
    I recently created a Macro for attaching data labels to a scatter graph (this is the 1st time I've ever done this). It appeared as though it was working but then after I looked at it, I realized that it is not pulling the X axis values onto the graph, it is simply assigning a (1, 2, 3, 4...) to the x axis and graphing the Y axis only. Also, I was only wanting the Country Name "label" to pull through, but instead on the graph as the label it is showing the Country name and X axis (that is not being graphed).

    I have attached a copy of the file in question with the chart and data file (and macro - "Alt 11" to get to Macro)...if anyone out there can help me to fix this problem, I would really appreciate it. It's really frustrating not being able to get this to work.

    Thank you!
    Last edited by lmausolf; 06-16-2012 at 08:48 AM. Reason: need to add file

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,120

    Re: Issue with X axis values NOT graphing on Scatter graph and issue with Labels

    The xaxis is using (1,2,3..) because currently your X values contain text and not numeric data.

    If you split the country name from the x value, so you have 3 columns of data then your chart will plot correctly the x,y values.
    You can then modify you code to use the cell to the left of the x data point for the data labels text.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

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