+ Reply to Thread
Results 1 to 4 of 4

Graph with numbers after RIGHT/LEFT formula

  1. #1
    Registered User
    Join Date
    05-15-2019
    Location
    Belgium
    MS-Off Ver
    365 ProPlus
    Posts
    2

    Graph with numbers after RIGHT/LEFT formula

    I would like to make a linegraph of a list of measurements but it doesn't seem to work after I used the "RIGHT" command. Anyway to work around this or do I need to retype every measurement?
    The measurements I read out has time, date and the actual measurement in one cell so I do need to select a certain part of that cell

    Thanks in advance!
    Last edited by bramfristi; 05-15-2019 at 04:54 AM.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Graph with numbers after RIGHT/LEFT formula

    the only reason I can think of is that Right might be outputting a text instead of a number, try to add -- to the front of your right formula or *1 to the end of it to convert it to numeric (same applies to LEFT). Otherwise, post a sample workbook so we can have a look.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    05-15-2019
    Location
    Belgium
    MS-Off Ver
    365 ProPlus
    Posts
    2

    Re: Graph with numbers after RIGHT/LEFT formula

    Quote Originally Posted by Sambo kid View Post
    the only reason I can think of is that Right might be outputting a text instead of a number, try to add -- to the front of your right formula or *1 to the end of it to convert it to numeric (same applies to LEFT). Otherwise, post a sample workbook so we can have a look.
    Yes! Thank you so much for the quick reply. It works!!!

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Graph with numbers after RIGHT/LEFT formula

    good, glad that was all that was the issue. If that takes care of your issue don't forget to mark the post as solved using the thread tools dropdown at the top of the post.

+ 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. Replies: 4
    Last Post: 03-02-2019, 06:19 PM
  2. [SOLVED] Struggling to use Vlookup and Left formula with telephone numbers
    By ExcelsBiggestFan in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-27-2016, 02:49 PM
  3. Is there a formula that will extract the numbers to the left of the cell
    By benji1973 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-04-2015, 10:11 AM
  4. [SOLVED] Formula to use numbers from left and right of cell to create a date
    By maryren in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-19-2013, 04:03 PM
  5. Replies: 2
    Last Post: 01-27-2013, 12:20 AM
  6. Replies: 1
    Last Post: 11-23-2012, 03:35 PM
  7. Y Axis Displayed on left and right of graph
    By Bob Smith in forum Excel General
    Replies: 2
    Last Post: 01-28-2005, 10:06 AM

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