excel表格怎么做mekko

1.请教EXCEL 达人如何做waterfall chart

This tutorial shows how to make a waterfall chart. I will use a table with one column to show the idea, but it's not too hard to do it for two or more variables. At the bottom of the page you can find two sample excel sheets. waterfall 1 step1. in my waterfall chart, i wanted to have the total, but it's straightforward to remove it by either deleting the total row in the spreadsheet, or by editing the chart source. here's a template if you're in a hurry excel-logo.png waterfall chart 2 step2. be careful with the formula you enter for the second column. i could have instead used "=sum(C7:C11)" applying this formula to cells below would make no difference, except if you decide to put more numbers just below the first column, then you'd be in trouble。

moving on。 waterfall chart 3 step 3. if you click on the preview button, you'll see that it doesn't look that good, but don't worry, we'll get there。

waterfall chart 4 step 4. yes, now we have the skeleton. waterfall chart 5 step 5. in this step, i think ahead and try to pick the bars i'll make invisible. this will save me from right-clicking and choosing "format data series" again. small note: be careful to pick the group of bars, not just one bar, or the whole chart waterfall chart 6 step 6. i wish 'print screen' showed the mouse pointer sometimes, but you get the idea。 waterfall chart 7 step 7. some people don't like gridlines under the waterfall chart, if you're one of them, pick white for the border and fill colors instead of picking "none" (and i'm sorry for stating the obvious :P) waterfall chart 8 step 8. just another modification i like, you don't have to。

in fact, if you're dealing with more than one variable, you might want to play around with the overlap and gap width a little bit waterfall chart sample ok, here it is.. hope this helps. feel free to use this excel sheet as a guide.。

2.请帮我做一个 Excel 的PSI 谢谢

Ei图标搜索 2.7软件等级： 更新时间：2009-01-19 软件类型：国产软件 软件大小：1.33 MB 软件语言：简体中文 软件授权：免费版 应用平台：Win9x/Me/NT/2000/XP/2003 官方主页：

下载地址 查看评论 模板下载

Ei图标搜索 2.7 使用安装方法说明：1、从各类文件提取位图、图标、光标，自动将Bmp、jpg、jpeg、gif、png、wmf、emf等21种图形文件转为图标格式。

2、可以指定文件夹搜索，也可以指定几个文件搜索。

3、可删除搜索到的不需要的图标。

4、可以将图标保存为图标集文件以便以后调用。

5、可以将选择的图标保存为ico 、bmp、png、jpg、gif格式的文件。

6、查看源图，右键选择搜索到的图标，在弹出菜单中选择“查看源图”，并提供源图裁剪和保存功能。

7、可提示、定位图标来源文件，提示二进制文件的资源类型及资源名。

8、兼容低版本图标集文件。

9、界面支持多语种（目前支持中文、英文）。

3.如何在EXCEL中生成目录

打开要创建目录的EXCEL文件--------Alt+F11---------插入--------模块--------把下面的代码拷贝到模块中Sub mulu()On Error GoTo Tuichu

Dim i As Integer

Dim ShtCount As Integer

Dim SelectionCell As Range

ShtCount = Worksheets.Count

If ShtCount = 0 Or ShtCount = 1 Then Exit Sub

Application.ScreenUpdating = False

For i = 1 To ShtCount

If Sheets(i).Name = "目录" Then

Sheets（"目录"）.Move Before:=Sheets(1)End IfNext iIf Sheets(1).Name ShtCount = ShtCount + 1

Sheets(1).SelectSheets.AddSheets(1).Name = "目录"End IfSheets（"目录"）.Select

Columns("B:B").Delete Shift:=xlToLeft

Application.StatusBar = "正在生成目录…………请等待！"

For i = 2 To ShtCount

ActiveSheet.Hyperlinks.Add Anchor:=Worksheets（"目录"）.Cells(i, 2), Address:="", SubAddress:= _

Sheets(i).Name & "!R1C1", TextToDisplay:=Sheets(i).NameNextSheets（"目录"）.Select

Columns("B:B").AutoFit

Cells(1, 2) = "目录"

Set SelectionCell = Worksheets（"目录"）.Range("B1")

With SelectionCell

.HorizontalAlignment = xlDistributed

.VerticalAlignment = xlCenter

.AddIndent = True

.Font.Bold = True