spot_img

How To Read Value From Graph in Excel

In this article we are going to learn how to read values from graph. The graph in this case is a bar graph comparing the movie ticket sold in a week and 2 week.example chartFirst you need to download the MPOC add-in. MPOC stands for Manipulate Points On Chart.Now that you have downloaded the ADD-in you need to add it in Excel. To do this open Excel, click on File, Click on Option, Click on Add-in. Select Manipluate_Points_on_chart.

Clink the “go” button to Manage Excel Add-Ins

Manipluate_Points_on_chart

Check the “Excel Add-in for Manipulating Points on Charts” Add-In and click OK.

Note: Add-In is now enabled and available every time you boot Excel.

add-ins

A Manipulate Points button will now appear whenever a chart object is selected under the Chart Tools -> Layout Tab of the Ribbon

Note: In Excel 2013, you simply have to click on the ADD-In tab and select Manipulate Button.

ribbon manipulate points

Click on the chart, click in ADD-in tab and select Manipulate Points.

click chart

A dialog box will appear. Choose the Series in the dropdown in this case we select ironman 2 tickets sold in jan.

Note you can just select the series by clicking on the dropdown menu.

drop down menu

Choose a Point. Let us choose “Point 2”. The value of this point will be automatically shown in the Value Textbox. (OR just click on the point within the series on your chart).

choose point

Use the Spin Button or Textbox or Sliders to change the values of the chart.

change values

The new value will be written onto the worksheet cell that corresponds to this point on the chart. The chart will be updated to show this new value instantly.

That’s it.

Template

You can download the Template here – Download
spot_img
Previous articleHow To Link Objects In Excel
Next articleGoogle Classroom Tutorial