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

Excel圖表總結(jié)詳細(xì)步驟？

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

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

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

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

3圖表標(biāo)題、坐標(biāo)軸標(biāo)題、圖例的排布設(shè)置。

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

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

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

5添加圖表趨勢線。

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

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

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

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

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

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

Standard_devSTDEV(A:A)(數(shù)據(jù)的標(biāo)準(zhǔn)方差）

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

二、向下填充。

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

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

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

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

4、考慮。

四、修整圖形

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

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

關(guān)閉，如圖。

五、更改后系列圖表類型

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

2、選中后“拆線圖”。

3、確定。

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

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

大功告成！?。?/p>

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

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