# Category: Excel charts

## Show Excel Sparklines for Hidden Data

Do you use the sparklines that were introduced in Excel 2010? Last week, I was building a dashboard, and wanted to show sparklines for expenses and revenue. It didn’t go smoothly at first, but...

## Compare Word Counts in Excel Chart

It’s week two in the free online Infographics and data visualization course, led by Alberto Cairo, and I’m working on this week’s assignment. The discussion this week is about a New York Times graphic...

## Link Pivot Chart Title to Report Filter

Recently, I enrolled in an online Infographics and data visualization course, and the classes started last week. The instructor is Alberto Cairo, who wrote The Functional Art: An Introduction to Information Graphics and Visualization....

## Create a Line Column Chart on 2 Axes in Excel 2010

When you create a chart in Excel 2010, you can select a chart type on the Ribbon’s Insert tab.   For some charts, instead of selecting one type, you might like to combine two...

## Excel Dot Plot Chart for Stock Prices

Today we’ll create an in-cell chart that shows the latest price for a stock, compared to its low and high prices. There is a sample file available for download, and a video that shows...

## How to Create a Panel Chart in Excel

To show a concise, clear summary of data for several departments or cities, you can create a panel chart in Excel. It shows all the data in a single chart, with vertical lines separating...

## Interactive Excel Sample Data

There’s sample data on my Contextures website, and it’s useful for testing formulas and pivot tables in Excel. On that page, there’s a link to a downloadable Excel file, with the same sample data....

## Show Data From Hidden Rows in Excel Chart

You can add a chart in Excel, based on worksheet data, like this sales chart example. But, if you filter the data, and rows are hidden, that data also disappears from the chart. You...

## Show Excel Chart or Data in Dashboard With No Macros

In this Excel dashboard example, you can select "Chart" or "Chart Data" from a drop down list. Magically, with no macros in the workbook, the selected item appears on the worksheet. With this technique,...

## Create Excel Chart With Shortcut Keys

To create a chart in Excel, you can select the data on the worksheet, then use the Ribbon commands to insert the chart. Use the Keyboard Shortcuts If you’d rather use the keyboard to...

## Pocket Price Waterfall Chart in Excel

I’m working on some pricing reports for a client, and one of the requests was for a Pocket Price Waterfall chart. I hadn’t made one of those before, and fortunately the client sent me...

## Do Not Build This 3-D Chart in Excel

My eyes are still burning from this experiment, so read on at your own risk! Last week, you saw this book cover, here on the Contextures blog. I asked if you, as the author,...