Categories
Excel

Date or Time Scaling in a Chart

Excel handles dates and times by treating them as numbers, allowing it to adjust the chart scale accordingly. When you input actual dates, Excel automatically recognizes them and adjusts the chart. But what should you do if Excel doesn’t represent the text as dates on the chart?

Categories
Excel

How to Change the Scale on a Graph (Chart)

The chart scale is like the ruler for a chart or graph. It tells us the smallest and biggest numbers we see on the chart. It also shows how the numbers are spread out. By following these steps, you can change the scale on a graph (chart) in Excel to better visualize your data.

Categories
Excel

Use Non-Contiguous Ranges to Create Charts

A common assumption is that charting data requires a single, contiguous table. However, sometimes you may want to chart only a subset of the data in a table, and the columns you need may not be adjacent. This situation is not uncommon, but it requires some extra steps when creating your chart.

Categories
Excel

Use Dynamic Named Ranges to Create Charts

Follow this tutorial if you want your charts to automatically update with new data as soon as you add it to your spreadsheet.

Categories
Excel

Create Two Sets of Slices in One Pie Chart

Most people think pie charts are limited to a single set of values, but here is a way to create a pie chart based on two columns of values.

Categories
Excel

Explode a Single or All Slices from a Pie Chart

Although pie charts are excellent visual aids, sometimes you want to emphasize a particular piece of the pie. Separating it from the rest gives it more attention.

Categories
Excel

Extract PivotTable Data Using GETPIVOTDATA

The GETPIVOTDATA function can be useful when you want to reference a specific value in a pivot table without using cell references, which may change if the pivot table layout changes. You can also use the function to perform calculations with pivot table data, such as summing or averaging values that meet certain criteria.

Categories
Excel

Save or Share Pivot Table Without Source Data

A static copy of the PivotTable is a good option when you want to share it with others but want to keep its data confidential. A static copy does not contain the underlying data that the original PivotTable uses, so you can control what the recipient can see. Another benefit of a static copy is that it has a much smaller file size than the original PivotTable, which makes it easier to send and store.

Categories
Excel

Automate PivotTable Creation

One way to create pivot tables automatically is to use the Recommended PivotTables feature. This feature scans your data and suggests some possible pivot tables that you can choose from. You can also use VBA to create pivot tables automatically. VBA gives you more control and flexibility over the pivot table creation process.

Categories
Excel

Create a PivotTable

How to quickly create a summary of your data based on the fields you choose using a PivotTable (or using a recommended PivotTable feature). You can use a PivotTable to analyze your data in different ways and find insights that might otherwise be hidden.