excel柱状图怎么添加对数趋势线Excel图表总结详细步骤？

excel柱状图怎么添加对数趋势线 Excel图表总结详细步骤？

excel图表总结详细步骤？

1是需要是再插入图表，框选表格，接着点击菜单的插到-图表格式，选择自己需要的图表格式，一个都差不多的图表就创建完成了。

其实我们也可以不按f11快捷键进行图表的创建战队，创建出的图表在单独的图表页中，这个功能是对后期图表的操作不太比较方便，这里就不做累述。

2下面可以介绍图表的基本是功能。

切换图表的行列：点左键单击图表，菜单中进去两个新的菜单-图表工具，图表工具中有3页命令-设计、布局、格式，打开设计页面，再直接点击【切换行/列】，就可对图表行列进行对换。行列的排布依据自己的要求来设置。

3图表标题、坐标轴标题、图例的排布设置。

相对于添加标题来说，在设计页面中的图表布局和布局页面中的标签，都能实现方法。更多情况下，我们是生克制化设计和布局页面来对图表格式参与你操作。.例如，不显示图表和坐标轴标题，因此图例说明坐落下方，我们是可以中,选择布局3，在布局页面中选择坐标轴标题中的相对应命令

4改图表没显示的数据范围。

再点电脑设计页面中的【选择数据】，会自动弹出数据你选窗口，在此窗口中也可以通过数据的重新编辑。诸如我们你选择张三的各科成绩创建家族表格。我们还也可以对图例项和水平轴标签通过可以编辑。

5添加图表趋势线。

相对于图表，我们是可以去添加一条数据变化的趋势线。这个功能没法在二维图表中利用。所以简单我们将三维柱状图转成二维柱状图。再点击改图表类型来更改。后再切换到行列。再点击趋势线，你选择其他趋势线选项，弹出趋势线选项窗口，据那些要求选择。本例选择类型对数线，会显示公式

excel怎样画对数正太分布的图？

一、获取正态分布概念密度

正态分布概率密度正态分布函数“normdist”某些。

在这里是以分组边界值为“x”来算出：

meanaverage(a:a)(数据算术平均）

standard_devstdev(a:a)(数据的标准方差）

cumulative0(概率密度函数）

二、向下填充。

三、在直方图中增加正态分布曲线图。

1、在直方图内右键→选择数据→添加→。

2、系列名称：选中后h1单元格。

3、系列值：选中后h2:h21。

4、考虑。

四、修整图形

1、在图表区柱形较下方鼠标右键点击正态分布曲线数据，（正态分布密度值和频率数值两者相比太小了，真是完全看不清，多试两次，鼠标右键点击后如图，同样的正太分布曲线那数数据在全选状态）。

2、右键→可以设置数据列格式→系列草图在→次坐标轴；

关闭，如图。

五、更改后系列图表类型

1、选中后正态分布柱形图→右键→改系列图表类型。

2、选中后“拆线图”。

3、确定。

六、平滑正态分布图。

选中后正态分布曲线→右键→设置数据列格式→线型→选项卡“平滑线”→关了。

大功告成！！！

本例中原始数据：

51.7,50.6,57.9,56.9,56.7,56.7,55.3,56.1,53.7,54.5,56.9,51.9,52.1,55.1,54.9,54.7,55.3,55.3,54.5,54.9,54.5,55.3,54.9,54.3,53.7,53.5,53.7,53.1,54.5,53.1,53.9,53.5,53.3,53.9,53.5,53.5,52.5,53.3,53.5,53.3,53.7,53.1,54.5,53.9,56.7,54.5,54.3,55.1,54.1,54.5,53.9,53.1,53.3,55.3,55.7,56.1,54.7,53.1,53.3,52.7,53.1,52.9,53.1,54.3,53.1,52.7,53.1,53.3,53.1,53.3,53.1,53.3,55.1,54.7,54.9,54.3,53.9,53.7,53.9,53.5,54.5,54.3,55.5,55.7,55.5,54.9,55.3,55.5,53.7,54.1,53.9,55.7,55.9,53.7,53.5,53.1,52.3,52.7,52.9,53.3,53.9,52.7,53.5,53.1,52.7,51.9,52.5,53.9,54.5,55.7,55.3,54.9,53.1,52.9,54.1,53.3,54.7,53.9,54.3,54.1,53.7,53.3,52.7,52.9,52.5,53.9,53.5,54.1,54.1,54.7,54.9,54.9,54.1,53.3,52.9,53.7,53.9,54.3,54.1,54.5,54.7,54.9,52.1,52.9,53.5,52.7,53.1,53.1,53.5,52.9,52.9,53.1,53.3,52.7,53.5,53.9,54.9,55.1,54.3,55.1,54.3,54.3,53.9,54.5,54.5,54.3,55.3,54.5,54.9,53.5,52.1,55.3,55.7,55.7,55.5,54.5,57.7,54.7,53.7,53.1,53.7,55.9,56.1,53.9,53.7,53.3,53.9,53.9,54.5,54.7,56.1,55.7,53.1,53.7,53.5,53.9,53.9,53.5,53.3,53.1,52.5,55.9,55.7,54.1,54.3,54.1,54.1,54.5,54.5,55.1,53.1,53.3,54.1,54.3,53.9,54.1,54.7,54.7,53.7,53.1,53.3,52.7,53.5,52.9,53.7,56.5,56.1,55.7,55.5,56.9,57.7,56.5,55.7,54.1,54.7,55.7,55.5,53.1,52.7,53.1,53.3,53.5,54.3,54.1,54.5,54.7,55.7,55.5,54.1,54.3,54.7,53.1,53.3,53.1,52.7,53.1,53.7,53.1,54.7,54.5,55.1,54.7,54.5,56.1,55.7,53.3,52.5,53.7,54.1,53.3,52.1,52.3,53.1,53.3,53.5,53.3,53.1,52.7,53.1,55.7,55.1,54.3,53.7,53.1,52.9,53.1,52.7,52.5,53.1,53.5,53.1,53.3,54.1,55.1,54.9,56.1,55.7,56.5,54.7,53.7

图表数据图格式曲线