|Download Help (Windows Only)|
The Word Graphs and Pictures VIs and Excel Graphs and Pictures VIs support all the graph types that Microsoft Office uses. The following table defines some of the most commonly used graph types. Refer to the specific version of Microsoft Word or Microsoft Excel that you are using for a complete list of available graph types.
|XY or Scatter||Displays the relationship or degree of a relationship between the numbers in several graph data series or plots two groups of numbers as one series of XY coordinates. XY graphs show uneven intervals of data. Arrange data with x values in one row or column, followed by one or more corresponding y values in adjacent rows or columns.
|Area||Displays the relative importance of values over a period of time. Although area graphs appear similar to line graphs, area graphs emphasize the amount of change or magnitude of values.|
|Line||Displays trends or changes in data over a period of time at even intervals. Although line graphs appear similar to area graphs, line graphs emphasize time flow and the rate of change.|
|Column||Displays variation over a period of time or illustrates comparisons between items. Stacked and 100-percent stacked column graphs show relationships to a whole. Although column graphs are similar to bar graphs, column graphs organize categories horizontally and values vertically.|
|Bar||Displays individual figures at a specific time or illustrates comparisons between items. Stacked and 100-percent stacked bar graphs show relationships to a whole. Although bar graphs are similar to column graphs, bar graphs organize categories vertically and values horizontally. This type of organization places more emphasis on comparisons and less emphasis on time.|
|Three-dimensional surface||Displays a view that resembles a sheet stretched over a three-dimensional column graph. You can use surface graphs to find the best combinations between two sets of data. Surface graphs can show relationships between large amounts of data that might otherwise be difficult to see. Colors or patterns indicate areas that have the same value. The colors do not mark the data series. The wire frame format displays the data in black and white. Contour graph formats provide a two-dimensional view of the data from above, similar to a two-dimensional topographic map.|
|Pie||Displays the relationship or proportions of the parts to the whole. You can use pie graphs to emphasize a significant element. Pie graphs always contain one data series. If you select more than one data series when you create a pie graph, only one data series displays. Use a doughnut graph, a variation of a pie graph, if you want to display more than one data series in a round graph format.|