You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
It's often helpful to create charts that compare different types of data. For example, you might want to compare overall revenue with the number of units sold. To do that you need to know how to use different chart types in one chart and how to use a secondary vertical axis to plot values that are in a different value range. Read more to learn how. (Sample workbook included)
The title of this post sounds simple. Should be easy to do, right? But customers tell us that it's very confusing and not at all clear where to find the features to get the results they want. It all depends on what you want to merge or split. For example, you may want to create a large header cell by splitting the cells below it into a number of smaller cells.
I often create such headers but use a different method than you'd expect, because an individual cell simply cannot be split into smaller cells. Instead, I merge several cells into one larger cell above the cells for which it will be the header. The result is exactly the same.
Are you confused by how Excel handles percentage formatting, or by percentages in general? It's okay, you're not alone.
In this post, find out more about how Excel displays percentages, and learn basic techniques for calculating percent decrease, percent increase, and percent change.
Conditional formatting is a popular feature and is a great way to easily identify cells with a range that meet some criteria. However, users often want to create conditional formatting rules that go beyond comparing a cell’s value to a single value or a single cell reference - row or column comparisons are commonly requested operations. In this blog post, we will learn how to use relative references in conditional formatting rules to make such tasks easier.
Going, going, gone! Yes, it’s true that the Chart Wizard was removed from the product when we shipped Excel 2007, and we didn’t bring it back in Excel 2010.
For those of you upgrading from Excel 97-2003, this may come as a big shock. The Chart Wizard provided a useful four-step process that you could simply follow to create a chart with a finishing touch. Unfortunately, it didn’t make sense to update the Chart Wizard to incorporate the many changes that were made when the chart engine was rebuilt for Excel 2007. Instead, the ribbon became the new place to go for all your charting needs.
Keep reading to learn how easy it is to create and work with charts in Excel 2010.