Howdy Folks,<BR><BR>I have an Excel spreadsheet with several charts in it. Each chart has several data series plotted as xy scatter. I would like to change the marker size for each data series using ...

Excel spreadsheets can often contain large amounts of data ranging across broad categories. For example, a sales spreadsheet might record sales of products across multiple departments, or within ...

Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook. Before you apply this formula, check that each worksheet is formatted the same way.

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. Once you select the portion of your spreadsheet that contains the target data, then define it as a ...

Have you ever struggled to make sense of a dataset with too many categories or time-based data? It’s a common challenge—how do you present individual contributions while still showing the bigger ...

Q. Is it possible to produce a sparkline chart in Excel that displays a column chart with an overlaying line chart? A. The correct answer is no; you cannot create a sparkline chart in Excel that ...

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them. Microsoft Excel offers a plethora of tools for ...

A data set that occurs frequently consists of the values or the percentage breakdown of several categories for two time periods. A common way of plotting these data is to use a pair of pie charts.