Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Data Visualization Features in Excel 2010

04 Sep 2009   #1

Windows 10 Workstation x64
Data Visualization Features in Excel 2010

The Excel team has made several improvements in the data visualization area for Excel 2010 and been posting lots of details on the Excel Team Blog. First off, the Excel team added a visualization that you can use to enhance your spreadsheets, sparklines:

“For Excel 2010 we’ve implemented sparklines, “intense, simple, word-sized graphics”, as their inventor Edward Tufte describes them in his book Beautiful Evidence. Sparklines help bring meaning and context to numbers being reported and, unlike a chart, are meant to be embedded into what they are describing…”

Data bars and icon sets have been enhance to address important customer feedback.One of the biggest requests for data bars was negative data bars, which is now in Excel 2010:

“In Excel 2010, we have introduced negative value data bars which can help analyze trends when negative values are involved. By default, we smartly position the axis in the cell so that a small negative value will not occupy half the cell lengths when bigger positives values are also in the range. If you prefer, we let you position the axis in the center of the cell.”

Also, there are improvements to charting, especially around the performance and rendering of charts:

“In today’s article I will outline some of the significant new chart improvements that impact performance. In Office 2007 the graphics engine used by Office Charts was replaced with one that could support more complex rendering. A downside of this change was slower performance in certain scenarios relative to Office 2003. For example, supporting anti-aliasing in Office 2007 allows the chart to render smooth lines; however, the computation for smoothing takes multiple rendering passes which take additional time. One of the top priorities for Office 2010 was increasing chart performance.”

Here’s the full list of Excel blogs posts around sparklines, conditional formatting, and charting:

Sparklines in Excel

Adding Some Spark to Your Spreadsheets

Formatting Sparklines

Sparkline Axis Options

Sparklines – Lining Up the Points

A Sparkline Trick - Using the Horizontal Axis as a Reference Line

One More Sparkline Trick

Icon Set Improvements in Excel 2010

Data Bar Improvements in Excel 2010

More Conditional Formatting Features in Excel 2010

The DisplayFormat OM

Chart Object Model in Word & PowerPoint

Improvements to Chart Performance

More Charting Enhancements in Excel 2010



My System SpecsSystem Spec
04 Sep 2009   #2

Win 7 Pro x64, VM Win XP, Win7 Pro Sandbox, Kubuntu 11

Again, thanks for the information. It is good to have someone on top of things.
My System SpecsSystem Spec

 Data Visualization Features in Excel 2010

Thread Tools

Similar help and support threads
Thread Forum
features in Excel
What features have you found in Excel that would be useful to the management team? how would you use them?:(
Microsoft Office
Excel 2010 Script error popup when getting data from Web
Hi there I sometimes get a script error when getting data from web when using Excel 2010. This seems to depend on the ISP I'm using as I can take the laptop into some Wifi enabled Cafe's and EXCEL gets the data without the error popup. Since I like to run some of these as background...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Excel 2010 - Accessing data based on conditions from other sheets
I've tried goggling this a bit and can't seem to find exactly what I'm looking for. I'm trying to setup a sheet that can run calculations based upon what someone else enters (ex: if they select 'option1', preferably from a drop down list, then two values will be set to the corresponding values,...
Microsoft Office
Business Intelligence Features in Excel 2010

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 09:28.
Twitter Facebook Google+