+ Reply to Thread
Results 1 to 4 of 4

Data transform to graph

  1. #1
    Registered User
    Join Date
    02-29-2020
    Location
    Malaysia
    MS-Off Ver
    Office 365
    Posts
    65

    Data transform to graph

    Hi,

    I have 18 graph data and i want to move that data to graph similar to this image. Any idea how to do that? Appreciate your help.
    Thanks.

    IMG_1951.jpg
    Attached Files Attached Files

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

    Re: Data transform to graph

    Both charts look like basic XY scatter charts.

    For the second chart:
    1) Select G2:H23 -> Insert Scatter chart.
    2) Excel's default behavior will be to use the left column (column G) for the Xvalues and the right column(s) for the Y values, so go into the Select data dialog and switch the X and Y values.

    The procedure for the first chart is the same, except that all your data entries are text strings, so you will need to edit them to change them to real numbers.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    02-29-2020
    Location
    Malaysia
    MS-Off Ver
    Office 365
    Posts
    65

    Re: Data transform to graph

    Hi MrShorty,

    I'm not familiar to the graph in Excel. How to edit Y and X axis to the real number?

    Thanks.

  4. #4
    Registered User
    Join Date
    02-29-2020
    Location
    Malaysia
    MS-Off Ver
    Office 365
    Posts
    65

    Re: Data transform to graph

    Oh i think i get what you mean. need to convert it to number right. thanks. i will try to do that.

+ 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. Data Transform in excel
    By rahulofcoer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-09-2020, 10:15 PM
  2. [SOLVED] Transform Data
    By orgetorix in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2019, 09:37 AM
  3. How to Transform data quizz?
    By tta.akmal in forum Excel General
    Replies: 1
    Last Post: 06-12-2018, 10:25 AM
  4. Using SQL to transform Excel data
    By cyiangou in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-02-2015, 05:46 AM
  5. Transform Data Set
    By whitehead6682 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2011, 09:17 AM
  6. Transform the format of data
    By caldera55 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2008, 01:20 PM
  7. Transform Data from A1,b1,C1 to A50,A51,A52
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2007, 05:33 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