The Chart Wizard of earlier versions may be gone in Excel 2007, but creating charts is still as easy as ever. Beyond building basic charts there are various techniques you can use to make your charts ...

Create a report using charts: Select Insert > Recommended Charts, then choose the one you want to add to the report sheet. Create a report with pivot tables: Select Insert > PivotTable. Select the ...

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, ...

Excel’s REPT function is a hidden gem that can transform your bar charts from ordinary to extraordinary. This function allows you to repeat text a specified number of times, allowing you to simulate ...

Excel remains an essential tool for data management, analysis, and visualization. In 2025, its evolving features and refined techniques make it more powerful than ever. But have you ever found ...

The new Analysis ToolPak is designed for complex statistical and engineering work. However, it’s not turned on by default so you need to activate it yourself when you want to use it. Go to the main ...

The Change Chart Type utility in Microsoft Excel features several graphs from which you can select to convert your current Excel chart into a graph. Choosing a new graph type from the utility ...

This article will be handy if you want to rename or edit the data series name in a Microsoft Excel graph or chart without changing the row or column name. The data series is the data that appears at ...

Excel won't display hidden data in a chart unless you flip the switch. Learn which option controls this behavior. By default, Excel displays only visible data in a chart. Consequently, if you hide ...

Simpler and faster is always better in Excel. We start with some of my favorite shortcuts, then move on to using Excel for everyday situations such as finding random numbers for passwords, or random ...