擅長講解-如何做一張簡單的圖表或圖擅長

張貼在2007年7月27日在5:00 pm

保證讀其他崗位從擅長講解系列!

擅長是您能使用創造圖和圖表為小的一個強有力的工具或很多數據。在這中擅長講解，我將顯示您如何採取一個小數據設置和與您必須定做圖表的選擇一起創造一張簡單的長條圖。一旦您有基本下來，您在更大的數據設置能使用那些同樣技術。

首先，我創造了一套學生測驗數據為我們的例子。有八名學生與他們的測試分數在四檢查。要做此成圖，您首先想要選擇數據的整個範圍，包括標題(測試1等等)。

即然您的數據被選擇得如所示上述，開始并且點擊 圖巫術師 按鈕在擅長工具欄。按鈕有一張小的圖表裡面它作為像。如果您不能看像或它不在您的工具欄，您能點擊 插入物 菜單和選擇圖.

為巫術師的第1步，我們需要採摘我們想要顯示數據關於的這种圖表。記住，即使您採摘錯誤一個，您能稍後總改變圖類型。為我們的例子，點擊酒吧并且選擇首選在第二列：

您能點擊「按并且舉行觀看樣品」得到什麼的預覽圖將看似。逐字地有您能選擇從的許多圖類型，因此繼續并且通過預覽不同那些戲耍。點擊其次配置源數據。在第2步，我們可以告訴擅長我們是否在系列要它讀數據從列或從專欄。 This might not make sense, but in our example if you choose Rows, the Y-axis is the Tests and for each test, all of the names are lines in the graph:

In this graph, I can easily compare each student’s grade on each exam. If you choose Columns, we’ll see each student along the Y-axis and their scores as lines in the graph:

Easy huh? Ok once you pick the graph style you like, click Next. Step 3 allows us to customize a few necessary items of the chart, such as the Title, units for the X and Y axes, the position of the legend, and whether or not the values should be listed on the graph.

I went ahead and added a Title, moved my legend to the bottom so my chart has more horizontal space, and added labels to the bar lines. Click Next and choose whether you want to create the graph in a new sheet or dump it on the same sheet as an object. Here’s our final chart:

That’s it! Of course there is a lot more stuff you can do with the chart (like change those horrible default colors) if you right-click in the empty white space, but that’s for another lesson.

Technorati Tags: microsoft excel, excel help, excel tutorials, how to make a chart in excel, make a graph in excel, create charts in excel, excel graphs