+ Reply to Thread
Results 1 to 2 of 2

Plot graph function in Excel

  1. #1
    Registered User
    Join Date
    10-23-2019
    Location
    Berlin
    MS-Off Ver
    2016
    Posts
    1

    Plot graph function in Excel

    said that I have a function y=f(x) in an interval [x1,x2]. I want to plot the graph in the interval with a step xs.
    1 how can I define in Excel a vector [x1:xs:x2], using the step xs?
    2 how can then plot the function f?

    thanks

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,546

    Re: Plot graph function in Excel

    The easiest way I can think of would be to link the data to a second table on which the graph would be based.
    Attached is a simple example.
    1. A1:B11 display the original data
    2. A20:B30 display the second table where A21:A30 are populated using: =IF(A2<=D$20,A2,NA())
    3. B21:B30 are populated using the original function
    4. Cell D20 shows the step number to display. (test by changing step number)
    Note that the graph used is a scatter chart.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Failure to plot a Bar graph in Excel 2010
    By jmasanganise in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-24-2019, 08:46 PM
  2. How to Plot Ratio of Calls in Excel Graph
    By egrizzly in forum Excel General
    Replies: 2
    Last Post: 10-20-2016, 01:11 PM
  3. Replies: 1
    Last Post: 04-11-2006, 12:50 PM
  4. [SOLVED] How to plot semi log graph in Excel?
    By Omkar in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-10-2006, 03:50 AM
  5. [SOLVED] Excel: plot graph
    By quest in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-17-2005, 08:05 AM
  6. Replies: 3
    Last Post: 10-13-2005, 12:05 AM
  7. Can you plot a graph with 3 axes e.g. xyz values on Excel?
    By Khan in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-29-2005, 09:05 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