Excel图表宝典(英文版) - 图表初步

Excel图表宝典(英文版) - 图表初步 

一.Understanding Chart Types 理解图表类型
     Conveyinng a Mesage with a Chart 用图表表示信息
     Choosing a Chart Type 选择图表类型
    Standard Chart Types 标准图表类型
     Excel's Standard Chart Types
    Chart Type    Subtypes
     Area   6  
    Bar   6
    Column   7
    Line   7
    Pie   6
    Doughnut  2
    Radar   3
    XY(Scatter)  5
    Surface   4
    Bubble   2
    Stock   4
    Cylinder  7
    Cone   7
    Pyramid   7
    Column chart SubTypes  柱形图
        Clustered column 簇状柱形图
        Stacked clumn  堆积柱形图
         100% stacked column 百分比堆积柱形图
         3-D clustered column 3D簇状柱形图
         3-D stacked column 3D堆积柱形图
         3-D 100% stacked column 3D百分比堆积柱形图
         3-D column  3D柱形图
    Bar Chart SubTypes
         Clustered Bar   簇状条形图
         Stacked Bar   堆积条形图
         100% stacked Bar  百分比堆积条形图
         3-D clustered Bar  3D簇状条形图
         3-D stacked Bar  3D堆积条形图
         3-D 100% stacked Bar 3D百分比堆条形图
         3-D Bar   3D柱条图
         Line Chart SubTypes
         Line   折线图
     Stacked line  堆积折线图
         100% stacked line  百分比堆积折线图
         Line with data markers 数据点折线图
         Stacked line with data markers   堆积数据点折线图
         100% stacked line with data markers 百分比堆积数据点折线图
         3-D line  3D折线图
         Pie Chart SubTypes
         Pie   饼图
         3-D pie   3D饼图
         Pie of pie  复合饼图
         Exploded pie  分离型饼图
         Exploded 3-D pie 分离型3D饼图 
        Bar of pie  复合条饼图
     XY(Scallter) Chart Subtypes
         Scatter     散点图
         Scatter with smoothed lines  平滑散点图
         Scatter with smoothed lines and no data markers 无数据点平滑散点图
         Scatter with lines   折线散点图
         Scatter with lines and no data markers 无数据点散点图
         Area Chart Subtypes
         Area     面积图 
         Stacked area    堆积面积图  
         100% stacked area   百分比堆积面积图
         3-D area    3D面积图
         3-D stacked area   3D堆积面积图
         3-D 100% stacked area   3D百分比堆积面积图
     Doughnut Chart Subtypes
         Doughnut    圆环图
         Exploded doughnut   分离圆环图
    Rader Chart Subtypes
         Radar     雷达图
         Radar with data markers   数据点雷达图
         Filled rader    填充雷达图
     Surface Chart Subtypes    
         Surface(top view)   曲面图(俯视)
         Surface(top view wireframe)  曲面图(俯视框架图)
         3-D Surface    3D曲面图  
         3-D Surface(wireframe)   3D曲面图(框架)
     Bubble Chart Subtypes
         Bubble chart    气泡图
         bubble with 3-D effect   3D气泡图
     Stock Chart Subtypes
         High-low-close    盘高-盘低-收盘图
         Open-high-low-close   开盘-盘高-盘低-收盘图 
         Volume-high-low-close   成交量-盘高-盘低-收盘图 
         Volume-open-high-low-close  成交量-开盘-盘高-盘低-收盘图
      Cylinder,Cone,and Pyramie Chart Subtypes
         Clustered column
         Stacked column
         100% stacked column
         Clustered bar
         Stacked bar
         100% stacked bar
         3-D column

二. Customer Chart Types 自定义图表类型
 Area blocks,B&W eare,B&W column,B&W line-timescale,B&W pie,Blue pie,Colored lines,
 Column-area,Column with depth,Cones,Floating bars,Line-column,Line-column on tow axes,
 Lines on two axes,Logarithmic,Outdor bars,Pie explosion,Smooth lines,Stack of colors,Tubes
    Excel图表示例文件:xl8galry.xls

三．Working With Chart Series 图表操作

Add New Series
     1. using Drag-and-Drop 拖动数据到图表
     2. using Paste Special COPY数据后,选择性粘贴到图表
     3. using the Source Data dialog box 使用图表菜单->添加数据
Delete Series
         Select Series Press Del
Modifying the Data Range for a Char Series
     1.Drag the range highlights
     2.Use the Source Data dialog box
     3.Edit the SERIES formula
          =SERIES(series_name,category_lables,values,order,sizes)
          =SERIES(散点图!$E$1,散点图!$C$2:$C$5,散点图!$E$2:$E$5,2)
   系列名,X轴数据,Y轴数据
          series_name 系列名,当只有一个系列时,默认为图表名,可以包括固定文本. 
          category_lables 分类轴,对于xy图,表示X轴的值.(可以包括多个区域)
          values(必须) 系列值,对于xy图,表示Y轴的值.(可以包括多个区域)
          order(必须) 不能进行引用,指定系列的的次序(1,2..).
          sizes(起泡图) 
     4.Changing a series name 图表菜单->源数据,也可以修改SERIES formula
     5.Deleing a series name  图表菜单->源数据,也可以修改SERIES formula
Adjusting the Series Plot Order 调整系列次序
Charting a Noncontinguous Range 图表中使用多个区域
Using Series On Different Sheets 图表中使用多个工作表(同一工作薄) SheetName!R1C1
Handing Missing Data 操作丢失的数据 
         对丢失的数据,可以进行以下操作
     Ignore the missing data.Plotted data series will have gap. 忽略,产生一个间隔.
     Treat the missing data as zero values. 视数据为零
     Interpolate the missing data(for line and XY charts only) 以内值插入 
         操作如下: Select Your Chart,Choose Tools->Options->ChartTab->appropriate opion
    Controling a Data Series by Hiding Data 通过隐藏数据操作系列数据
    Active the chart and select th Tools->Options->ChartTab Remove the checkmark from the option labeled Plot visble celss Only.
Using Range Names in a SERIES Formule 在系列工式中使用名称(对区域或单元格定义名称).
          如,区域A2:A1定义名称为Days,区域B2:B11定义名称为Calls对应的系列工式为:
          =SERIES(Sheet1!$B$1.,CallVolume.xls!Day,CallVoulme.xls!Calls,1)
Unlinking a Chart Series form Its Data Range 断开图表的数据链接
     1.Convert the chart to a picture.  转换图表为图形.
           Cilick the chart to activate it,Press the Shift key and choose Edit->Copy Picture. Choose Edit ->Paste
     2.Convert the range references to arrays. 转换图表数据区域引用为固定数组.
           =SERIES(,{"WordK","Sleep","Drive","Eat","Other"},{9,7,2,1,5},1)
           Create the chare as usual,Click the chare series,Click the formula bar,Press F9,Press Enter.
           限制,EXCEL imposes a 1,024-character limit to length of a SERIES formula!
Using Combination Charts 使用组合图形
     1.Creating combination charts
           通过支持以下三种组合图表 Column-area,Line-column,Line-cloumn on two axes
  多好人没的注意到,EXCEL可以建立好多种组合图形.(选择一个多个系列中一个进行修改,更改为另一种图形样式,一个系列可以有一种图形样式)
     2.Working with multiple axes 使用多个轴进行工作
          A chart can use zero,two,three or four axes,and any or all of them can be hidden if desired.
 Pie charts and doughnut charts have no axes. 饼图和环形图没有轴
         Common chart types,such as a standard column or line chart,use a single category axis and a single value axis.标准核图,线图使用一个分类轴,一个数值轴.
          If your chart has at least two series-and it's not a 3-D chart you can create a secondary value axis. 如果你的图表有两个轴,并且是非3-D图表,你可以建立多个数值轴.
          Each series is associated with either the primary or the secondary value axis.每一个系列都关联了一个主要的或次要的数值轴.
          Why use two value axes?Two value axes are most often used when the data being plotted varies drastically in scale.
     1>.Creating A Secondary Value axis 建立一个两个数据轴的图表
           打开数据系列对话框->座标轴->格式,次要座标轴
     2>.Creating A Chart With Four Axes 建立一个有四个轴的图表
           使用两轴折线图，显示次坐标轴.见图http://blog.csdn.net/images/blog_csdn_net/qffhq/177177/o_四轴图表.JPG