Category Archives: Content

How to Plot a Formula in Excel

By Chad Davis, Contributor at ExcelAssignment company.

To create a spreadsheet table that can be plotted in the form of a graph, first calculate your X or Y values. In Microsoft Excel, you can generate results for these variables by applying a formula to a known data series. Once you’ve completed your table, you can use your X and Y data to automatically create a scatter chart with straight lines and markers. Use the Chart tools to label each axis on your chart, and then label the data callouts for each point on the X and Y axes.

Instructions

  1. Create a new blank workbook in Excel.
  2. Enter your formula into cell A1 for reference. For example, enter “y=5x-2” (without quotes here and throughout).
  3. Enter labels for your X and Y column data into cells A2 and B2. For example, label the cells “X” and “Y”.
  4. Enter your X-values into the first column, starting in cell A3. For example, enter the following values into cells A3 through A7: “-2, -1, 1, 2, 4”.
  5. Select cell “B3,” and then calculate its Y-value using your formula. For example, enter “=5*A2-2”, and then press “Enter” to compute the value for Y.
  6. Select cell “B3” again, and then drag the fill marker, resembling a small box in the bottom right corner of the cell, to the bottom of your data series. For example, drag the fill marker from B3 to B7. Your Y-values are computed based on your formula and corresponding X-values in the table.
  7. Select your formula in cell A1. Click on the “Insert” tab to switch to the Insert ribbon. Click the “Insert Scatter (X,Y) or Bubble Chart” drop-down button, resembling a scatter chart icon, and then click “Scatter with Straight Lines and Markers” to plot your formula in a chart.
  8. Click the “Add Chart Element” drop-down button in the Chart layouts group of the Design ribbon, select “Axis Titles,” and then click “Primary Horizontal” to add a horizontal axis title to your chart. Repeat the process, but this time select “Primary Vertical” to add your vertical axis title. Replace the titles with the labels you used for your X and Y data. For example, enter “X” for the horizontal axis title, and then enter “Y” for the vertical axis title.
  9. Click the “Add Chart Element” drop-down button again, select “Data Labels,” and then click “Data Callouts” to label your data markers.

Tips & Warnings

Information in this article applies to Microsoft Excel 2017. It may vary for other versions or products.

Protecting Creativity, Expanding Consumer Choice

Respect for copyrights is central to the ability of creative artists to make great movies and help our economy grow. The MPAA is committed to protecting the rights of those who create the content we love. We also understand that this means embracing new technologies and innovative approaches that enable consumers to enjoy their favorite movies and TV shows in exciting and flexible ways.

From the creative arts to the software industry, more and more people around the globe make their living based on the power of their ideas. This means there is a growing global stake in protecting intellectual property rights and recognizing that these safeguards are a cornerstone of a healthy global information economy.

More than 2.5 million American jobs rely upon a healthy film and television industry in the United States. We are committed to safeguarding these opportunities while delivering innovative choices to consumers. To be successful, we know we have to constructively engage with diverse stakeholders. This includes:

  • Partnering with the technology community to expand the diversity of legitimate choices available to consumers, so they can enjoy the genuine article — authentic copies of movies & TV shows — at a fair price and in flexible and hassle-free ways.
  • Working to include strong intellectual property rights provisions in every U.S. trade agreement and working to ensure that all parties uphold the commitments we have made to one another to protect the power of ideas around the world.
  • Partnering with law enforcement and other entities to safeguard intellectual property rights as a cornerstone of our global information economy.
  • Collaborating with educators to promote respect for copyrights at an early age, teaching the importance of responsible digital citizenship.
  • Working constructively with consumers to enlist their support and respect for intellectual property rights.