提升Excel 2007图表技巧：数据可视化与高级应用

需积分: 4 135 浏览量更新于2024-08-02 收藏 7.79MB PDF 举报

"《EXCEL.2007.CHARTS.MADE.EASY》是一本实用指南，专为提升用户在Microsoft Excel 2007中的图表制作技巧而设计。本书作者Kathy Jacobs、Curt Frye和Doug Frye共同编著，帮助读者超越基础的饼图和条形图，探索并利用Excel 2007提供的丰富数据可视化功能。本书详细讲解了如何通过手动格式化图表组件，创建专业且富有吸引力的效果；例如，如何使用线图展示数据趋势，结合线图和饼图形成面积图，以及如何利用散点图和气泡图来展示数据关系。书中还涉及了股票图表的创建与格式化，以及表面图技术，通过连接三个数据点来展现复杂的数据关系。此外，雷达图被用来比较不同数据值，而PivotTables和PivotCharts则展示了如何处理动态数据，使得数据分析更加灵活和高效。作者指导读者如何将Excel图表无缝融入Word文档和PowerPoint演示文稿，提高信息的呈现效果。版权方面，所有内容受1976年美国版权法保护，未经出版商The McGraw-Hill Companies事先书面许可，不得任何形式复制、分发或存储于数据库或检索系统。该电子书内容也同步出现在印刷版《EXCEL.2007.CHARTS》中，ISBN: 978-0-07-160006-4和MHID: 0-07-160006-X。本书尊重商标权，仅在编辑风格下提及商标，以保护商标所有者的权益。对于本书中出现的商标，通常采用全大写字母表示，但并不构成侵权。对于企业或个人希望批量购买作为奖励或促销礼品，McGraw-Hill Books提供了特别的优惠折扣。这是一本实用且深入的工具书，适合Excel 2007用户提升他们的数据可视化技能和工作效率。"

Chapter 1 Creating and Formatting a Basic Column Chart

To create the chart, you start by selecting the data to chart. Once you have

the data selected, create the chart using Insert | Column. From the column

charts available, select the chart type you want to use. Select the ﬁrst option,

a 2-D chart where the columns are clustered together.

Did you notice that when the chart was created, the available tabs in Excel

changed? When you are working with any chart, you will get three new tabs:

the Design, Layout, and Format tabs.

Use the Chart Tools | Design tab, shown in Figure 1-3, to work with the

basic colors and design of the chart. The buttons on this tab enable you to

change the type of the chart, what is shown in the chart, the colors of the

chart, and basic layout of the chart.

Figure 1-2 Data table – total

sales per day for four weeks

Figure 1-3 The Chart Tools | Design tab

Excel 2007 Charts Made Easy

Making It Clearer

The clarity of your chart isn’t just related to the clarity of your data. It also has

to do with making it easy for someone looking at the data to draw conclusions

from the data. As with many things in life, how you present your data will

help people see what you want them to see.

No matter what kind of chart you are creating, one of the easiest things you

can do to make it clearer is to make it bigger. You could grab one of the corners of

the chart and expand it. This would leave the chart on the same page as the data.

At ﬁrst glance, that seems to be a good idea. However… if you leave your chart

on the same page as the data, there is a good chance that it will cover up your

data and get in the way when you are working with it. Charts on the same page

as data are also easy to accidentally delete. I recommend…

The next step is to turn on the legend. One way to do this is to use the

Chart Tools | Layout | Legend button. This button lets you select where you

want the legend to show on your chart. To activate your legend, click the

button and select from the drop-down list. You can also add the legend by

choosing a chart layout (which will be covered at the end of this chapter) or by

using More Legend Options, which will be covered in Chapter 2.

Series π The groups of data being charted.

In this example, each week is a series. If the

chart had just shown the values for each date,

with no grouping, there would be only one

series in the chart. Series are usually shown in

a chart by using a common color or other ﬁll

for the bars related to that series.

Gridlines

π The lines on the background

of the chart that help indicate what value

the column represents. Gridlines can run

horizontally, vertically, or both.

Legend

π The map showing which color or ﬁll

represents which series.

Title

π The heading at the top of the chart.

This is the descriptive text that tells the story

you want the audience to learn from the chart.

Data sheet grid

π The actual data used to

create the chart. This is not usually shown,

but can be helpful if the differences between

the data points don’t show well on the chart.

The Language of CharTing (ConT.)

Chapter 1 Creating and Formatting a Basic Column Chart

The third step in improving your chart is to decide if the data is grouped

the way you want it to be. Any data in a column chart can be grouped by rows

or columns. By default, Excel groups your data by rows. This means that the

data was grouped by weeks, with each week containing seven bars. If you

want to know which of the weeks have the best and worst sales, you could

tell it from this chart. However, if you want to know which were the best and

worst days, you need to make a change.

Click the Chart Tools | Design | Switch Rows/Columns button. Notice

that the grouping of the data swaps from weeks to days. Now you can tell at

a glance that Saturdays are the best days and Wednesdays are the worst days.

Changing the grouping of your data can sometimes tell you things you didn’t

know the data had to say.

X, Y, Z – Axis to Axis

The column chart in this chapter has been created as a two-dimensional

chart. You might think about this as being drawn on a wall of a room. It is

ﬂat. The x axis is the line between the ﬂoor of the room and the wall itself.

The y axis is the line between the wall and the one to its right. The higher the

value for a column, the taller it is on the wall. The more columns you have,

the narrower each is, since they all have to ﬁt on the same wall.

But this isn’t all there is to a column chart. You can create a third axis. You

might think of this as moving the chart from the wall to the middle of the

room. The bottom of the chart then becomes the entire ﬂoor instead of just a

line. This isn’t just changing the shapes in the chart to have depth and edges.

This is adding depth to the chart by adding a third axis to the chart: the z axis.

The third axis isn’t just an axis where data is plotted. It is a change to how

the chart looks and how the data in it is perceived. One of the advantages to

having the third axis is that you are no longer restricted to looking at the chart

face-on. You can change your view of the chart so that you can see it from

above, below, or any side.

To see how the third axis changes your chart, click Chart Tools | Design |

Change Chart Type. The list of available charts will show up. For now, pick

With the chart

selected, ﬁnd and

click the Chart Tools |

Design | Move Chart

button. Select the

New Sheet option,

and give the new

sheet a descriptive

name. Click OK. A

new sheet will be

added to your Excel

ﬁle. This sheet will

contain the chart

and only the chart.

By placing your chart

on its own page, you

ensure that the chart

won’t be accidentally

deleted by a mis-

click while you are

working with your

data. In addition,

by placing it on its

own sheet in the ﬁle,

the chart itself will

be bigger and more

readable.

The easy Way

剩余207页未读，继续阅读

icingrock

粉丝: 0
资源: 2

提升Excel 2007图表技巧：数据可视化与高级应用

最新资源