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

If you are looking to improve your Microsoft Excel spreadsheet and data analysis skills you may be interested in this Advanced Excel Tips & Tricks tutorial from the team over at SSIT. Mastering ...

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