A treemap chart provides a hierarchical view of data and makes it easy to spot patterns. Learn how to create a treemap chart in Excel.

Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

When collaborating in Excel, sometimes the collaboration can be distracting. Here's how to make a static image so you can do your own work without interruption.

Figure B The Excel add-in inserts a chart populated with dummy data. How to connect the Excel data to the chart At this point, you’re ready to connect the chart to real data.

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up.