Convert text dates to real dates to allow the date-based axis to work.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Replace columns or bars in a chart with a shape
If you can not get your pivot table formatting correct while the report is a real pivot table, this video has a great solution for you. Build a shell report to hold the formatted results.
Sort a pivot table field using a custom list. This requires too many steps in PowerPivot.
Interacting with a pivot table in the Excel Web Application.
Calculate % of parent item in a pivot table.
Some actions in the Excel interface cause an alert to appear, such as the Are you sure you want to delete this worksheet?" message. These alerts can be annoying in a macro. This episode takes a look at how to remove that alert
The new themes in Excel offer six accent colors. Learn how to take those six theme colors and turn them into 1200 colors using Tint and Shade.
