Choose Excel Dashboard Chart in Drop Down List

Choose Excel Dashboard Chart in Drop Down List http://blog.contextures.com/archives/2015/07/30/choose-excel-dashboard-chart-in-drop-down-list/

You can make an interactive dashboard in Excel, even if you can't use macros, or prefer to avoid them. Select a chart or chart data from a drop down list, and the selected item will instantly appear on the dashboard – no macros required.

See how to build this dashboard, watch the video, and download the sample file to see the completed version.

Name That Range

In the screen shot above, "Chart Data – East" is selected in the drop down list, and that data will appear on the dashboard, replacing the current data.

There are 4 choices in

Continue reading Choose Excel Dashboard Chart in Drop Down List

Excel Roundup 20150720

Weekly Excel Roundup http://blog.contextures.com/

In this week's roundup, let me know if you like the version of Excel that you're using at work, get productivity tips, add a sneaky filter to a pivot table, and more.

We're on our summer schedule now, so the next roundup will be published on Monday, August 3rd.

Continue reading Excel Roundup 20150720

Copy Numbers Only in Excel

Copy just the numbers in Excel http://blog.contextures.com/

Someone emailed me recently, asking how to copy just the numbers, from a column that also contained some blank cells. The goal was to paste those numbers in another location, in a solid block, without all the blanks.

Continue reading Copy Numbers Only in Excel

Excel Roundup 20150706

Weekly Excel Roundup http://blog.contextures.com/

In this week's roundup, create bullet charts, export dashboards, use the Rank feature in pivot tables, and many other Excel tips

We're on our summer schedule now, so the next roundup will be published on Monday, July 20th.

Continue reading Excel Roundup 20150706

Show Rank in Excel Pivot Table

Add Rank to Excel Pivot Table http://blog.contextures.com/

A pivot table is a great way to quickly summarize number, to see how your business is doing. But sometimes those numbers are too large to analyze in your head, so let the pivot table give you a bit of help, with the pivot table Rank calculation.

Continue reading Show Rank in Excel Pivot Table

Excel Roundup 20150622

Weekly Excel Roundup http://blog.contextures.com/

In this week's roundup, plan your meals, fix dates, multiply cells, refer to tables, and many more Excel tips.

NOTE: Now that summer is here, I'll publish the Excel Roundup once every  two weeks, so you will see the next one on July 6th.

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

Continue reading Excel Roundup 20150622

Excel Weekly Meal Planner 20150618

Excel Weekly Meal Planner http://blog.contextures.com/

There is an Excel weekly meal planner on my website, and you can use it to organize your meals, and create a shopping list. I hadn't used it for quite a while, and after opening it this week, I decided it was time for an update.

Continue reading Excel Weekly Meal Planner 20150618

Excel Roundup 20150615

Weekly Excel Roundup http://blog.contextures.com/

In this week's roundup, add custom chart labels, get started with VBA, compare worksheets, get info from hyperlinks, and many more Excel tips.

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

Continue reading Excel Roundup 20150615

Compare Excel Worksheet Values and Formulas

Compare Cell Values and Formulas in Excel http://blog.contextures.com/

If Excel sheets are set up identically, you can create 3-D formulas, to sum a specific range, in a group of sheets. (You can use other functions in a 3-D formula too, such as Average, Count, Min or Max.)

For example, this workbook has sheets for the East, Central and West regions, and all three sheets are set up the same.

Continue reading Compare Excel Worksheet Values and Formulas

Excel Roundup 20150608

Weekly Excel Roundup http://blog.contextures.com/

In this week's roundup, build a nested IF formula, improve your dashboards, work with dates, and change a pivot table layout.

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!

Continue reading Excel Roundup 20150608