While static Excel charts are adequate for basic data analysis, they fall short when you want to explore trends, compare ...

That’s where Excel comes in. With its powerful suite ... From cleaning up messy datasets to creating dynamic charts and pivot tables, you’ll learn how to transform your data into visuals ...

Users will appreciate a chart that updates right before their eyes. In Microsoft Excel 2007 and Excel 2010, it's as easy as creating a table. In earlier versions, you'll need the formula method.

However, these charts are static. You could also consider creating Dynamic charts in Excel. By doing this, the curves in the graph would change as and when you change the value of the data.