In Excel, I created a Polynomial Trend Line for a column chart. The equation for this trend line is:
This may seem like such an easy question, but how do I put this into use in Excel, so that I can plug in X and get Y? I forget what the "E" is in the equation... I don't know how to read the equation in layman term.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.