Excel offers many different chart types—including column and bar graphs—to present your data. However, you don't have to settle for the preset column and bar layouts. Instead, you can swap these for ...

Type your data or use existing data from your file. Highlight the range of cells containing your data. Then click the Insert tab and click the Insert Column or Bar Chart button. Click the Clustered ...

If you want to create a pie chart in Excel, this step-by-step guide is for you. In this article, we would consider the Hierarchical Sunburst chart as a type of pie chart, though the procedure for ...

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format, and ...

Imagine you’re preparing for a big presentation at work, and you need to showcase the progress of your project over the past year. You have all the data, but it’s scattered across multiple ...

Whether working with a team or alone, you need to maintain a project’s schedule. One tool that can keep you on track is a burndown chart created in Microsoft Excel. These are line charts that compare ...

Is your chart boring? Try Excel’s people chart to liven things up. Susan Harkins shows you how. A people chart is an infographic, which leads me to a second definition. An infographic tells a story, ...

Waterfall charts are powerful visual tools that can help you understand the cumulative effect of sequentially introduced positive or negative values. They are particularly useful in financial analysis ...

One option for sharing reports with your team is to simply rattle off numbers. Think something like this: "We allocated 10% of operating budget to maintenance, 15% to hardware upgrades, 18% to ...

Microsoft recently made some significant enhancements to its Visio add-in for Excel, enabling users to create Visio diagrams from within Excel. Here's how it works. Even though Visio is easily one of ...

Every time Melanie publishes a story, you’ll get an alert straight to your inbox! Enter your email By clicking “Sign up”, you agree to receive emails from ...