+ Reply to Thread
Results 1 to 5 of 5

Digitizing (Converting) a picture of graph to excel data

  1. #1
    Registered User
    Join Date
    11-25-2022
    Location
    KSA
    MS-Off Ver
    Microsoft Office Professional Plus 2019
    Posts
    1

    Question Digitizing (Converting) a picture of graph to excel data

    Hello everybody,

    I?m wondering if there is any tool in excel or extension that converts a graph or a plot (as an image) to excel data (table or plot)?

    I am aware that there are some software and websites that can do that

    But, I would like to know if I can achieve that through MS Excel

    I really do appreciate your response.

    Thank you.

  2. #2
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Digitizing (Converting) a picture of graph to excel data

    No, is not possible, sorry!
    Diana Tanase


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

  3. #3
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,302

    Re: Digitizing (Converting) a picture of graph to excel data

    without detail your request is a bit vague - there are ways using VBA/macro - see if this link helps.
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

  4. #4
    Forum Contributor
    Join Date
    09-03-2016
    Location
    Catania, Italy
    MS-Off Ver
    Excel 2019
    Posts
    164

    Re: Digitizing (Converting) a picture of graph to excel data

    Hi to all
    Try this (not easy but ...)
    proceed as follows:
    - on the sheet insert an Image control
    - you associate (Picture property) your image to the control
    -as PictureSizeMode choose property 2
    -then you assign this code to the image:
    Please Login or Register  to view this content.
    -in a cell of column A write "Zero", the next cell leave it blank
    -in the cell below write "Max", leave the cell next to it free, the one next to it again (therefore in column C) write the maximum value the graph must reach (I wrote 6)
    Finally select the cell where you want to create the values of the points of the graph; I positioned myself in D19.
    And then:
    -click on the "zero" axis of the graph; the cell next to Zero will be filled in
    -click on the maximum height of the graph; I clicked on the vertice up-left
    -finally click on the first point of the first series; the corresponding value is loaded into the active cell
    -move to the adjacent cell and click on the second value of the serie
    -continues horizontally for the other values of the serie

    I hope this help. I attach my work.
    Hi, Mario
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    09-03-2016
    Location
    Catania, Italy
    MS-Off Ver
    Excel 2019
    Posts
    164

    Re: Digitizing (Converting) a picture of graph to excel data

    Hi
    EngMohammad & Others

    Have you seen my proposal?
    Thanks.
    Hi,
    Mario

+ 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. Changing Data labels on top of Picture in graph
    By Thinkstudio in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-15-2018, 02:14 AM
  2. [SOLVED] Converting a picture into excel
    By Phlegon_of_Tralles in forum Excel General
    Replies: 1
    Last Post: 10-18-2018, 05:46 PM
  3. [SOLVED] Digitizing a logarithmic graph
    By MarmaladeLover in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 09-30-2014, 05:51 AM
  4. [SOLVED] Converting From Range to Table is squashing data in Graph
    By ChemistB in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-04-2012, 08:50 AM
  5. Graph Problems Converting from Excel 2003 to 2007
    By gav0101 in forum Excel General
    Replies: 1
    Last Post: 07-21-2010, 12:08 PM
  6. [SOLVED] How do I take a picture and make it a graph in Excel?
    By DavidBr318 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-05-2006, 11:55 AM
  7. Excel graph as Value/picture
    By Yunus Patel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-20-2006, 11:15 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