Excel圖表總結詳細步驟？1是需要是再插入圖表，框選表格，接著點擊菜單的插到-圖表格式，選擇自己需要的圖表格式，一個都差不多的圖表就創(chuàng)建完成了。其實我們也可以不按F11快捷鍵進行圖表的創(chuàng)建戰(zhàn)隊，創(chuàng)建

Excel圖表總結詳細步驟？

1是需要是再插入圖表，框選表格，接著點擊菜單的插到-圖表格式，選擇自己需要的圖表格式，一個都差不多的圖表就創(chuàng)建完成了。

其實我們也可以不按F11快捷鍵進行圖表的創(chuàng)建戰(zhàn)隊，創(chuàng)建出的圖表在單獨的圖表頁中，這個功能是對后期圖表的操作不太比較方便，這里就不做累述。

2下面可以介紹圖表的基本是功能。

切換圖表的行列：點左鍵單擊圖表，菜單中進去兩個新的菜單-圖表工具，圖表工具中有3頁命令-設計、布局、格式，打開設計頁面，再直接點擊【切換行/列】，就可對圖表行列進行對換。行列的排布依據自己的要求來設置。

3圖表標題、坐標軸標題、圖例的排布設置。

相對于添加標題來說，在設計頁面中的圖表布局和布局頁面中的標簽，都能實現(xiàn)方法。更多情況下，我們是生克制化設計和布局頁面來對圖表格式參與你操作。.例如，不顯示圖表和坐標軸標題，因此圖例說明坐落下方，我們是可以中,選擇布局3，在布局頁面中選擇坐標軸標題中的相對應命令

4改圖表沒顯示的數(shù)據范圍。

再點電腦設計頁面中的【選擇數(shù)據】，會自動彈出數(shù)據你選窗口，在此窗口中也可以通過數(shù)據的重新編輯。諸如我們你選擇張三的各科成績創(chuàng)建家族表格。我們還也可以對圖例項和水平軸標簽通過可以編輯。

5添加圖表趨勢線。

相對于圖表，我們是可以去添加一條數(shù)據變化的趨勢線。這個功能沒法在二維圖表中利用。所以簡單我們將三維柱狀圖轉成二維柱狀圖。再點擊改圖表類型來更改。后再切換到行列。再點擊趨勢線，你選擇其他趨勢線選項，彈出趨勢線選項窗口，據那些要求選擇。本例選擇類型對數(shù)線，會顯示公式

Excel怎樣畫對數(shù)正太分布的圖？

一、獲取正態(tài)分布概念密度

正態(tài)分布概率密度正態(tài)分布函數(shù)“NORMDIST”某些。

在這里是以分組邊界值為“X”來算出：

MeanAVERAGE(A:A)(數(shù)據算術平均）

Standard_devSTDEV(A:A)(數(shù)據的標準方差）

Cumulative0(概率密度函數(shù)）

二、向下填充。

三、在直方圖中增加正態(tài)分布曲線圖。

1、在直方圖內右鍵→選擇數(shù)據→添加→。

2、系列名稱：選中后H1單元格。

3、系列值：選中后H2:H21。

4、考慮。

四、修整圖形

1、在圖表區(qū)柱形較下方鼠標右鍵點擊正態(tài)分布曲線數(shù)據，（正態(tài)分布密度值和頻率數(shù)值兩者相比太小了，真是完全看不清，多試兩次，鼠標右鍵點擊后如圖，同樣的正太分布曲線那數(shù)數(shù)據在全選狀態(tài)）。

2、右鍵→可以設置數(shù)據列格式→系列草圖在→次坐標軸；

關閉，如圖。

五、更改后系列圖表類型

1、選中后正態(tài)分布柱形圖→右鍵→改系列圖表類型。

2、選中后“拆線圖”。

3、確定。

六、平滑正態(tài)分布圖。

選中后正態(tài)分布曲線→右鍵→設置數(shù)據列格式→線型→選項卡“平滑線”→關了。

大功告成?。。?/p>

本例中原始數(shù)據：

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