The Excel Team Blog : Charting

Intro to Power View for Excel 2013

Excel Blog — Thu, 04 Oct 2012 07:00:00 GMT

Have you ever looked at a dashboard someone made and went, “man, I like that, but there’s too many steps for me to remember”? Or maybe wanted to have a way to play around with your data in a safe space so you don’t mess it up? Power View is a new add-in for Excel 2013 that consumes the Data Model. For those who are avid readers of our blog, you will remember Diego did a post on the Data Model we’ve integrated into Excel. If you don’t remember that post (because...(read more)

Inserting Charts in Excel 2013

Excel Blog — Thu, 27 Sep 2012 15:23:00 GMT

As Scott mentioned in his Charting Overview post , users have always struggled with picking the right chart type to represent their data. Unless you have a good understanding of the different chart types available and the types of data they work for, many users have trouble choosing the right chart type to properly represent their data, and often fallback to choosing something familiar. Even worse, sometimes users ended up choosing chart types that misrepresent their data, changing the message they’re...(read more)

Charting Overview for Office 2013

Excel Blog — Thu, 06 Sep 2012 07:01:00 GMT

With the Office 2013 release, the Office DataViz team is proud to deliver a rich set of charting capabilities across Excel, Word, PowerPoint, and Project. In fact, because there are so many features, this article will only be an overview. Subsequent articles will go into the specific use cases and steps for each of them. I’ve been working on Excel charting since the Office 2007 release, when we replaced the charting engine, changed the rendering layer, and enabled charts to run on the server...(read more)

Go beyond the basic chart type

Excel Blog — Tue, 27 Sep 2011 19:10:00 GMT

Excel comes with lots of predefined chart types, including column, line, pie, and so on. However, many of you ask how to make other kinds of charts, such as floating column charts, Gantt charts, combination charts, org charts, flow charts, hierarchy charts, histograms, or Pareto charts. While none of these are available as predefined chart types, don't worry. There are ways to create these in Excel. ...( read more ) Read More......(read more)

Line or scatter chart?

Excel Blog — Tue, 30 Aug 2011 07:00:00 GMT

Ah, the great questions of life: Paper or plastic? Line chart or scatter chart? Choosing the wrong chart type for your data can easily happen when it comes to line and scatter charts. They look very similar, especially when a scatter chart is displayed with connecting lines, but there is a big difference in the way each of these chart types plots data along the horizontal and vertical axes. Let Excel writer Frederique be your guide as to which type of chart to use and when. ...( read more ) Read...(read more)

Apollo 11 & Excel – How did we do that?

Excel Blog — Mon, 08 Aug 2011 18:19:00 GMT

A couple of weeks ago, as part of our Watch History Reimagined series, we posted a video to show you how Excel might've helped the team at NASA work through some of the tensest moments in American history. Some of you asked us how we created certain visualizations that appear in the video. In today's post, we point you to the source workbook and data used to make the video and show you how to recreate a couple of the chart and slicer effects. Enjoy! ...( read more ) Read More......(read more)

Create Convincing Visualizations by Adding Reference Lines to Your Excel Charts

Excel Blog — Fri, 22 Jul 2011 02:58:00 GMT

Have you ever wanted to add a horizontal or vertical line to your chart to indicate a key value, sales threshold, important date, or the average of your data? Are you looking to impress managers and convince clients with your superb charts? Reference Lines (see the dotted black line on the chart below) can be powerful tools in effectively communicating important points in your data. There is currently no specific built-in functionality for creating Reference Lines in Excel 2010, but there are still...(read more)

Free training: Take the next steps in growing your Excel skills

Excel Blog — Tue, 28 Jun 2011 17:15:00 GMT

In early May, we told you about the new video series Excel Skills Builder in our post " Take the first step in growing your Excel skills ." In that post, we announced the launch of lesson 1. Well, we've finally finished the rest of the lessons, and wanted to share this great resource with you! As a reminder, the skills builder is a video series that comprises short (typically under 5 minutes each) videos that give you an overview of a task or feature in Excel. The videos are grouped...(read more)

Format column sparkline charts using the data axis and cell merging

Microsoft Excel — Tue, 01 Mar 2011 18:00:00 GMT

Sparkline charts are great, but there may be times they need a little visual massaging to maximize their usefulness. Consider this scenario: You have a system for which you want to track downtime over the course of a year and (fortunately) it had downtime events in only four of twelve months. Here's how to use and format sparkline charts to show this data effectively. ...( read more ) Read More......(read more)

Can’t find the Chart Wizard? No worries

Microsoft Excel — Tue, 07 Dec 2010 22:11:00 GMT

Going, going, gone! Yes, it’s true that the Chart Wizard was removed from the product when we shipped Excel 2007, and we didn’t bring it back in Excel 2010. For those of you upgrading from Excel 97-2003, this may come as a big shock. The Chart Wizard provided a useful four-step process that you could simply follow to create a chart with a finishing touch. Unfortunately, it didn’t make sense to update the Chart Wizard to incorporate the many changes that were made when the chart...(read more)

10 Days for Office 2010 Series – Reviewing the Dow Jones Industrial in Excel 2010

Microsoft Excel 2010 — Fri, 21 May 2010 07:00:00 GMT

Today’s post was written by Excel MVP Nate Oliver. Excel 2010 presents traditional numerical analysts with new and old tools; today we’ll explore two of them. The difference is that the first shall be what we call qualitative, and the second, quantitative. As a real-world example, on a really hot day, qualitative could mean hot, while quantitative could mean 100F. We shall explore both, with Excel 2010, with respect to the Dow Jones Industrial Average (DJIA). Read more here... Read More......(read more)

Hover Charts

Microsoft Excel 2010 — Thu, 11 Mar 2010 21:00:00 GMT

Thanks to Dan Battagin for writing this blog post. OK, so I'm sure everyone knows about the Freeze Panes feature in Excel - it's been around forever, and it's pretty useful in certain circumstances where you want to keep a row (or more) of data at the top of the sheet, or column on the side of the sheet - especially for filtering. Of course, we've made it a little less necessary in the 2007 and 2010 releases, since table headers (2007) and now table filters (2010) automatically camp...(read more)

Scatter charts with PowerPivot

Microsoft Excel 2010 — Wed, 24 Feb 2010 21:30:00 GMT

Rob over at http://powerpivotpro.com has a interesting post on scatter charts and PowerPivot: At right is a list of all chart types in Excel. But not all of them are supported as PivotCharts. Try to use XY (Scatter), Bubble, or Stock as a PivotChart, and you’ll get an alert saying you cannot create it with pivot data. So, do you give up? Nope. Remember the post where I converted a PivotTable to Cube Formulas using that button on the ribbon? This is a wonderful opportunity to use that feature in an...(read more)

Excel Add-In for Manipulating Points on Charts (MPOC)

Microsoft Excel — Mon, 02 Nov 2009 22:34:00 GMT

Overview In Excel 2007, the ability to directly resize or reposition points on the chart was deprecated. This feature was sometimes referred to as "Graphical Goal Seek." For example, in Excel 2003 a user could click on a data point in a column chart twice which would surface handles that could be used to resize the columns. Over the last couple of years we have received a lot of feedback from customers indicating that this was a valuable feature for some scenarios. However, we were not...(read more)

More Charting Enhancements in Excel 2010

Microsoft Excel — Tue, 25 Aug 2009 23:48:00 GMT

I’m back from my vacation (boy, Seattle is really gorgeous during the summer!). Thanks to Sam Radakovitz (Sam Rad) for filling in for me while I was out. And thanks to Ben Rampson and Robin Wakefield for putting together this final post on charting improvements in Excel 2010. In this post I’ll walk through some more of the new charting features available in Excel 2010. These include: PivotChart Interactivity Formatting Enhancements Parity Improvements Limit Increases Pivot Chart Interactivity In...(read more)