A picture graph is a visual method of displaying information that uses images or symbols to represent data. It includes a key or scale that indicates the value of each picture. One benefit of a picture graph is that it makes it easier for people to understand information. Data presented verbally is usually clarified when a picture graph is utilized. Picture graphs, however, often do not display data as accurately as other types of graphs. For example, in a picture graph illustrating the number of cars a dealership sells each month, an image of one car represents 10 cars sold. If the dealership sells 12 cars, the picture graph shows an image of one car along with a small portion of another car. This makes it difficult for the person viewing the graph to know exactly how many cars the dealership sold.
Charts are often used to ease understanding of large quantities of data and the relationships between parts of the data. Charts can usually be read more quickly than the raw data that they are produced from. They are used in a wide variety of fields, and can be created by hand (often on graph paper) or by computer using a charting application. Certain types of charts are more useful for presenting a given data set than others. For example, data that presents percentages in different groups (such as "satisfied, not satisfied, unsure") are often displayed in a pie chart, but may be more easily understood when presented in a horizontal bar chart.[2] On the other hand, data that represents numbers that change over a period of time (such as "annual revenue from 1990 to 2000") might be best shown as a line chart.
Excel Chart provides a way to represent data visually, but by customizing chart we can convert it in to pictograph (graph with pictures). It is an ideogram which convey its meaning through depicting images which resembles real-world objects, eventually making chart self-explanatory. Enhancing the chart would be very useful, it makes your audience comprehend the table data, without even looking at it. In this post we will be creating a simple pictograph. Launch Excel 2010, and open datasheet for which you want to create pictograph. For instance, we have included Office Items datasheet containing, Products, and No. Of Products, as shown in the screenshot below. office items
To start off with, first we need to include a simple column graph for the table Office Items. For this, select the column for which you want to create a chart, navigate to Insert tab, and from Column, select the basic 2-D Chart, as shown in the screenshot below. chart Upon click, it will automatically create the chart for you, showing Products in x-axis, and No. Of Products in y-axis. Give it an appropriate name at the top of the chart. office items graph
Now we will create Pictograph by adding picture instead of bars in the graph. For this select the first bar in the chart, click the bar two times (not double-click), to select it exclusively, as shown in the screenshot below. books Now head over to Insert tab, and click ClipArt. clipart From ClipArt Pane, we will search for book clipart, right click the clip art you want to include, and click Copy. book
Make sure that book bar is selected in the chart, now paste this image by pressing Ctrl + V. You will see stretched book image instead of bar, as shown in the screen shot below. book clip We want to show the number of books in the graph, by depicting same number of book images.
Right-click the stretched image and click Format Data Point. format data Upon click, Format Data
Point dialog will appear, from Fill, enable Stack and Scale with option. Hit Close to apply. format options Number of book images as defined in table which will be shown in the chart. images Now repeat the procedure for the other bars to place suitable images. pencil 1 As you can see in the
screenshot below that we have replace bars with images. chart complete Now we will change the style and design to make the items more prominent. For this, select the chart, you we will notice three
new tabs will appear. Choose suitable style, color, design, layout, chart type, gridlines, etc by accessing different groups from these tabs.
Blah what do those units actually means
Thanks so much for sharing this awesome info! I am looking forward to see more postsby you!
ReplyDeleteexcel vba training london