专业图表轻松做

专业图表轻松做

译者：snood   来源：http://blogs.msdn.com/excel 发表于：2006年7月7日

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 to make it possible, with no more than 3-4 clicks, to create a wide variety of professional-looking charts. 我在以前的几个贴子中描述“精美的文档”时提到过图表。在最近一到二周将详细介绍Excel2007图表。在一开始的二个贴子中，将讲述如何只用3-4步，轻松创建精美的专业图表。

Chart Types In current versions of Excel, when a user creates a chart, the first thing they need to do is select the type of chart – column, line, scatter, pie, surface, and etc. In Excel 2007, we’ve made the variety of chart types available a lot more visible, and we have offered help for users to choose between them. To insert a chart, a user would start with the Insert tab. Excel 2007 has an insert chart type “group” (7 related controls) on the ribbon’s insert tab. This makes it easy to pick a chart type, with large icons and tooltips that describe when to use a particular type. 图表类型 在当前版本中创建一个图表，第一步就是要选择图表类型：柱形图、折线图、散点图、饼图、曲面图等等。在Excel 2007中，有更多的图表类型以供选择。以下演示如何选择图表类型：在插入图表栏中插入一个图表，Excel 2007的插入菜单中有个插入图表栏（共七种图表类型）。利用大图标和细分图表类型的工具提示，可以非常容易地选择所需的图表类型。

Note that we have provided galleries for the most common chart types – column, line, pie, bar, area, and scatter – with the remaining chart types surfaced in a 7th gallery. For those who want to browse through the full list of chart types, or change the type of an existing chart, the Create Chart dialog makes it easier to explore the list of chart types and pick the one you want. Excel 2007除了提供最常见的图表种类：柱形图、折线图、饼图、条形图、面积图、散点图等，其余图表种类全部放在其它图表栏中。如果要浏览全部图表类型，或改变已有图表的种类，打开创建图表对话框可以容易地浏览和选择图表类型。

And for those who love shortcut keys, Alt+F1 will now create a chart object with the default chart type, while F11 still creates a chart sheet with the default chart type. 快捷键：Alt+F1在当前工作表中创建默认图表类型的图表对象；F11新建默认图表类型的图表对象

Although we do hear many customer requests for new chart types, unfortunately we weren’t able to add any in Office 2007. We’re not yet planning the next version of Office in depth, but no doubt that will be considered again, as this is another area where we hear a lot of feedback. 曾经有用户提出增加图表类型的请求，非常遗憾在Office 2007中我们未能提供更多的图表类型。我们计划在下个版本中深入研究和重新考虑，当然，也请你提供更多的反馈信息。

Chart Layouts Once a user has chosen a chart type, there are a variety of charting features that can help the user communicate their data effectively. In previous versions of Excel, these are scattered around through a variety of dialog boxes, making it hard for all but the most diligent users to take advantage of the settings. For Office 2007, we studied a massive number of charts that we found in publications, books, and Excel spreadsheets to determine the most common combinations of chart elements such as titles, legend, data table, etc. From this, we created a gallery of predefined chart layouts (e.g. combinations of chart elements) that can be applied with one click. Here is what the gallery looks like for a bar chart 图表版式 图表类型一旦选择后，用户为了获得更好的图表效果，需设置不同的图表元素。在早期的Excel版本里，是一个包含很多分散内容的对话框，对经常设置图表格式的用户来说比较麻烦。在Office 2007开发中，我们研究了大量刊物、书籍、Excel表格的中图表的标题、图例、数据表等元素的组合，从而设计了一个内置图表库(如组合图元素)，只要点一下鼠标就能运用到你的图表中了。

And here is what the galleries look like for a few other chart types. Note that each chart type has its own unique set of chart layouts. 这是内置的其他几个图表类型.每个图表类型都有自己独特的图表版式.

I have not included the pictures of the chart layouts for all the chart types, but I’ve tried to include those for most of the more popular chart types. We have tried to included layouts for the sorts of charts we are commonly asked about. For example, there’s a chart layout designed for making histograms – the third choice in the second row of the column chart layouts. There’s a chart layout designed for making sparklines – the first choice in the third row of the line chart layouts. There’s a chart layout designed for making pie charts with labelled slices instead of a legend. Each chart layout is a useful high-quality chart which presents data in a different way. We are still refining the set of chart layouts and their icons, so expect some changes before Office 2007 is done. 内置图表没有包括所有图表类型, 但尽量选择了一些最常用的的图表类型。我们为内置图表分类以满足用户的需求。例如, 直方图的图表版式设计- 在柱形图快选版式第二行的第三个图表；sparklines图的图表版式设计- 在折线图快选版式第三行的第一个图表；饼图的图表版式设计用图文框代替图例。在不同行业，每个图表版式都是有用的高质量图表. 我们还在完善这套图表版式及其图标,在Office 2007发布以前希望做一些变革。

Published Tuesday, April 11, 2006 9:49 AM by David Gainer

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。