In this article, we are going to learn how to read values from graphs. The graph in this case is a bar graph comparing the movie tickets sold in a week and two weeks.
Installing Manipulate Points On Chart add in
First you need to download the MPOC add-in. MPOC is an abbreviation for Manipulate Points On Chart.
Now that you have downloaded the ADD-in, you need to add it to Excel. To do this, open Excel, click on File, Click on Option, then click on Add-in. Select Manipulate_Points_on_Chart.
Clink the "go" button to manage Excel Add-Ins.
Check the "Excel Add-in for Manipulating Points on Charts" Add-In and click OK.
Note: The add-in is now enabled and available every time you boot Excel.
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 the Manipulate Button.
Reading off a graph
Click on the chart, click on the ADD-in tab, and select Manipulate Points.
A dialog box will appear. In this case, we chose Ironman 2 tickets that were sold in January.
Note: you can just select the series by clicking on the dropdown 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).
Use the Spin Button, Textbox, and Sliders to change the values of the chart.
The new value will be written on 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.
Further reading: How to calculate p value?