+ Reply to Thread
Results 1 to 2 of 2

Turn XY chart into usable data

  1. #1
    Registered User
    Join Date
    11-01-2017
    Location
    South Carolina
    MS-Off Ver
    2010
    Posts
    15

    Turn XY chart into usable data

    I'm not sure if I'm posting this in the correct spot or not and I don't know if my question has already been answered elsewhere since I have no idea how to sum it up! Basically, I have a chart of weights for various fasteners which is configured as X=Diameter, Y=Length with the weights listed in the chart. I want to import the weights into our software but it must be done as a complete formula. ie. M10X25 = 0.0125 lbs. each. Is there any way to take the excel data from the XY chart and put it into a usable format where it will display all lengths and diameters individually? I'm guessing this is VBA or maybe Access, but I don't know how to do it!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Turn XY chart into usable data

    I think we need a better idea of what your data and chart look like. I will note that I do not expect to do anything with the chart (assuming you are using chart as a graphical representation of the data and not a chart as in a table of data).

    A lot of the detail will depend on exactly how your data are arranged. Based on what I see, I would expect the formula to involve some kind of text concatenation. Maybe something like =CONCATENATE("M","10","X","25"," = ","0.0125"," lbs. each"). You can substitute a reference or formula for any of the arguments in this function to get parts of the final text string from wherever they are stored. That's about all I can guess at with the information given.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Convert poorly formatted vendor data into usable data
    By ncjackso in forum Excel General
    Replies: 3
    Last Post: 09-25-2017, 12:50 PM
  2. Convert Data into Usable database format
    By drbotts in forum Excel General
    Replies: 2
    Last Post: 07-02-2012, 01:31 PM
  3. [SOLVED] Trying to turn table of data into a chart with a filter
    By dwhite30518 in forum Excel General
    Replies: 5
    Last Post: 06-05-2012, 12:06 PM
  4. Format Data from Web so it's usable
    By bpbach in forum Excel General
    Replies: 5
    Last Post: 11-09-2009, 12:23 AM
  5. Replies: 1
    Last Post: 09-11-2007, 08:55 AM
  6. Making an old macro usable on new data
    By datahead in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-28-2007, 09:10 AM
  7. how to turn of a series in data sheet of a power point chart using macro
    By chepyalarr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2006, 03:10 PM

Tags for this Thread

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