专业图表轻松做-英雄云拓展知识分享

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

When talking to customers about charting in Excel, one of the big pieces of feedback we hear is how hard it is to make a chart that looks ready to publish. Generally, users aren’t graphic designers or experts in information visualization, yet they still want a result that looks professional and communicates their information effectively. With advent of the ribbon, we have a new UI design approach – results-oriented design (which is discussed in a blog post here). In a nutshell, the idea is to give users a couple of reasonable choices for professional designs, then allow them to mix and match those choices into a professional document. While we’ll still give users access to the detailed features that make their documents look good, they should be able to get close to a final result in just a few clicks. To that end, chart creation in Office 2007 can be as simple as making four straightforward choices that give users access to a vast range of possibilities. The four choices are: what type of chart they want, how they want the elements on that chart laid out, how they want their chart formatted, and what document theme they would like to use. I’ll talk about two of these choices in this post, and the other two choices in the next post.
用户在使用Excel图表时，重要的问题是利用现成的模板来创建图表。一般，使用者不是专业的图形设计师，他们只想得到一个能展现其数据效果的专业图表。在Exce2007中，有一个崭新的预览效果向导的用户界面。总之，这项目设计是为用户提供一系列的选择来完成专业设计的工作，然后经过组合和调剂创建专业图表。我们将详细介绍这些功能来创建精美的图表，使用户能经过几次点击便能完成图表。在Exce2007中经过简单的4个步骤创建图表，从而引导新用户入门。这4步是：选择图表类型，选择图表版式，设置图表样式，设置文档主题。在本贴我将介绍前面2步，其余2步在下一贴介绍。

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的插入菜单中有个插入图表栏（共7种图表类型）。利用大图标和细分图表类型的工具提示，可以非常容易地选择所需的图表类型。

(Click to enlarge)

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除提供最多见的图表种类：柱形图、折线图、饼图、条形图、面积图、散点图等，其余图表种类全部放在其它图表栏中。如果要阅读全部图表类型，或改变已有图表的种类，打首创建图表对话框可以容易地阅读和选择图表类型。

(Click to enlarge)

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表格的中图表的标题、图例、数据表等元素的组合，从而设计了一个内置图表库(如组合图元素)，只要点一下鼠标就可以应用到你的图表中了。

(Click to enlarge)

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.
这是内置的其他几个图表类型.每一个图表类型都有自己独特的图表版式.

Line Quick Layouts
折线图快选版式

Pie Quick Layouts
饼图快选版式

Scatter Quick 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.
内置图表没有包括所有图表类型, 但尽可能选择了一些最经常使用的图表类型。我们为内置图表分类以满足用户的需求。例如, 直方图的图表版式设计- 在柱形图快选版式第2行的第3个图表；sparklines图的图表版式设计- 在折线图快选版式第3行的第一个图表；饼图的图表版式设计用图文框代替图例。在不同行业，每一个图表版式都是有用的高质量图表. 我们还在完善这套图表版式及其图标,在Office 2007发布之前希望做一些变革。

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

选择英雄云的云表单=选择更智能的Excel

在现代企业管理中，数据的高效管理和处理至关重要。随着信息技术的不断发展，英雄云的云表单已经成为了提高数据录入、管理和分析效率的不可或缺的工具。让我们来深入探讨英雄云-云表单的几大优势。

基础字段：多样性满足业务需求

英雄云的云表单中包括了各种基础字段，如单行文本、多行文本、数字输入框、单选框、复选框、下拉框、下拉复选框、日期时间、分割线等。这些字段的多样性使用户可以根据具体的业务需求，轻松进行文本、数据和时间信息的录入或修改。例如，您可以使用单行文本字段录入员工姓名、产品型号等，或者使用下拉框进行多选，根据不同情况选择更加方便的字段类型。

高级字段：提升工作效率

英雄云的云表单还提供了高级字段，如地址、图片、附件、手写签名、手机、子表、关联数据、关联查询以及流水号。这些高级字段在基础字段的基础上升级，可帮助用户完成一些琐碎的工作。例如，使用地址字段可以避免逐字打字，而流水号字段可以自动生成规律性的编号，非常适用于合同编号生成等场景。

部门成员字段：精确管理与通讯录的关联

英雄云的部门成员字段允许企业对各个部门的成员进行精确管理。用户可以通过部门成员字段获取通讯录中的部门成员信息，应用于记录报销人、报销部门等场景。这些成员字段还细分为成员单选和成员多选，可根据具体需求在通讯录中选择一个或多个成员。

聚合表：数据处理更智能

英雄云的聚合表功能用于对已存在的表单数据进行聚合计算，从而得到一张聚合表，后续其他表单可调用聚合表进行数据联动、关联查询和关联数据等操作完成数据处理。这一功能可应用于多种场景，如进销存管理、财务管理和门店零售管理等，帮助企业完成数据处理，提高工作效率。

表单权限设置：灵活管理数据访问

英雄云的表单权限设置允许用户根据企业的具体需求管理表单的访问和操作权限。用户可以根据系统权限或自定义权限对不同成员或团队进行权限设置，以确保数据的安全和合规性。这一功能使企业能够根据变化的业务需求和团队结构，实时调整权限设置。

自定义打印模板：文档输出更便捷

英雄云的云表单支持自定义打印模板，可将表单数据转换为可打印的Word文档。用户可以根据自己的需求进行排版和编辑，将产品规格说明书等文档轻松生成。这一功能提供了一种标准化的文档输出方式，简化了信息整理的过程。

综合来看，选择英雄云的云表单意味着选择更智能、更灵活、更高效的数据管理工具。无论是提高工作效率，精确管理数据，还是实现数据处理，英雄云的云表单都能满足您的多样化需求，助力您的业务发展。

如果您正在寻找一款强大的云表单工具，不妨考虑英雄云，它将为您带来更多的便捷和智能，助您事半功倍。

免责声明：

本网址（www.yingxiongyun.com）发布的材料主要源于独立创作和网友匿名投稿。此处提供的所有信息仅供参考之用。我们致力于提供准确且可信的信息，但不对材料的完整性或真实性作出任何保证。用户应自行验证相关信息的正确性，并对其决策承担全部责任。对于由于信息的错误、不准确或遗漏所造成的任何损失，本网址不承担任何法律责任。本网站所展示的所有内容，如文字、图像、标志、音频、视频、软件和程序等的版权均属于原创作者。如果任何组织或个人认为网站内容可能侵犯其知识产权，或包含不准确之处，请即刻联系我们进行相应处理。