Capture relationships between data sets by graphing linear equations in Microsoft Excel 2007. Linear equations allow you to predict values within your data set and view the overall trend. Use ...

When you have too many data points to display in a dashboard chart, add a scroll bar so users can still view all the data. Sometimes a chart’s underlying data doesn’t fit in the chart window. When ...

Whether you are preparing a proposal for a new client or presenting your annual sales forecast, pie charts provide an instant visualization of complex numbers. Microsoft Excel includes a range of ...

If you understand the definition of a mathematical function, a good way to judge it is that any line drawn parallel to the y-axis intersects with the values in the function’s curve only once. The same ...

The Chart Wizard of earlier versions may be gone in Excel 2007, but creating charts is still as easy as ever. Beyond building basic charts there are various techniques you can use to make your charts ...

You can make a bar graph in Excel by first selecting the range of data you want to depict, and then using the dropdown menu to select the desired chart. A bar graph represents the data of an Excel ...

So, you want to know how to create a scatter plot in Excel. Chances are, you probably already know what the term means, but given Microsoft Excel’s arsenal of options packed into each tab, getting ...

To calculate the Consumer Price Index between two years in Excel, take a sum of all the amounts spent on the basket of products over those two years. Then use the following formula to find the CPI ...

I just tried this. Select all the data you want to have graphed, click on Insert, pick line graph, and choose which one you want. Excel (2007) automagically grouped date and time on the X axis. Edit: ...

Whether presenting a project at school, delivering a critical report at work, or simply trying to make sense of your budget, graphs are efficient and visually appealing means of conveying complex ...

How to create a YOY comparison chart using a PivotChart in Excel Your email has been sent Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in ...

Dana Miranda is a Certified Educator in Personal Finance, creator of the Healthy Rich newsletter and author of You Don't Need a Budget: Stop Worrying about Debt, Spend without Shame, and Manage Money ...