Microsoft Excel

Shadows on Charts and Cells in Excel 2007

Today's author, Helen Hosein, a Program Manager on the Excel team. Certain shadows created in Excel 2003 look different Excel 2007. In particular, you might notice that your old cell shadows, as well as shadows on things like Chart Titles might look a

Chart Templates

Today's author, Ben Rampson, a Program Manager on the Excel team. Customers who author charts in presentations and reports often spend a significant amount of effort modifying their charts to get them looking just the way they want. While the new Chart

Integrating Excel (Services) and PowerPoint with the Microsoft SDK for Open XML Formats

Today's author: Danny Khen, a program manager who works on both the Excel and Excel Services teams. What is this about? Office 2007 introduced new default file formats – Open XML. Excel, Word and PowerPoint take advantage of them. One of the nicest things

Intraday Time Series Charts

Today’s Author: Scott Ruble, a lead program manager on the Excel team who focuses on the area of data visualization. Scott is going to discuss how to create an intraday time series chart. Periodically, users need to create a chart where the data occurs

Chart Pattern Fills

Today’s Author: Eric Patterson, a program manager on the Excel team. Eric is going to discuss applying pattern fills to chart data points and includes a sample add-in for this purpose. Overview In Excel 2007, the interface for applying Pattern fills to

Combining Chart Types, Adding a Second Axis

Today’s author: Katherine Fifer , an intern on the Excel team. Katherine is just wrapping up a summer of fantastic work, and today she is going to discuss how to create a combo chart in Excel 2007. Often it is useful to create charts which compare different

A Bit More On Charting

Last week, in response to my post on charting, Harlan pointed at a few Economist charts as examples of professional charts. Today, I spent a few minutes with Excel 2007 trying to create a similar chart. I thought I would share the results. The chart in

Some Words About Charting

Over the past few months, when I have posted information about charting in Office 2007, there has been plenty of feedback and discussion about the work presented. Today, I wanted to spend a bit of time addressing some of that feedback. When I read over

Charting V – PivotCharts

Whenever we talk to users about PivotCharts, the first request we hear is that they behave more like regular charts. In previous versions, PivotCharts had very limited layout and formatting options. In addition, if you refreshed the PivotTable that the

Charting IV – Charts in PowerPoint and Word

One thing we know is that many of the charts that folks created in Excel end up in PowerPoint presentations or Word documents (I think the statistic is that 50% of all charts in PowerPoint presentations originate from Excel. While users work in Excel

Charting III – Tabs and Templates

In the previous two charting posts, I wrote about how you can make a professional chart with four simple choices – chart type, chart layout, chart style, and document theme. As useful as we hope that is, we know that some users will want to tweak and

Charting II – Professional charts, made easy (continued) + Excel 2007 keyboard access model …

Keyboard Access Today I want to start with a link to Jensen Harris' UI blog, where Jensen has put up a post that describes the Office 2007 keyboard model . I am personally a big keyboard user, and I know the same is true for a lot of Excel users, so this

Charting I – Professional charts, made easy

A few posts ago when I described the work we did in the area of “great looking documents” , I mentioned charting. I am going to spend the next week or two covering charting in detail. For this first two posts, I want to cover how we have used the ribbon

Quick detour – cool things on the status bar and great-looking charts

Today I decided to take a quick break from Excel Services to talk about a few small but useful changes that have been made to the status bar and show off a few charts First, the status bar Zoom control - we have added a slider that allows the user to