Former piersonforcongress.com writer Ted French is a Microsoft Certified experienced who teaches and also writes about spreadsheets and spreadsheet programs.

You are watching: Contains the actual values that are plotted on the chart


Charts and graphs in Excel and Google Sheets use data points, data markers, and data labels to visualize data and also convey information. If you desire to create powerful charts, learn how each that these elements works and how to usage them properly.


Data collection and other Chart facets in Excel

Data Point: A singlevaluelocated in a worksheet cell plotted in achart or graph.


Data Marker:A column, dot, pie slice, or one more symbol in the chart representing a data value. Because that example, in aline graph, each allude on the heat is a data mite representing a solitary data value situated in aworksheet cell.


Data Label: offers information around individual data markers, such as the value being graphed either as a number or together a percent. Generally used data brand in spreadsheet program include:


Category Names: identifies the separation, personal, instance data points in a single series of data. These are generally used because that pie charts.Percentage Labels: calculate by dividing the individual areas in a collection by the full value the the series. Percent labels are frequently used because that pie charts.

Data Series: A team of related data points or markers that space plotted in charts and graphs. Instances of a data series include individual lines in a line graph or columns in a obelisk chart. As soon as multiple data collection are plotted in one chart, every data collection is identified by a unique shade or shading pattern.


In obelisk or bar charts, if multiple columns or bars room the same color or have the same picture (in the situation of apictograph), they make up a solitary data series.


Pie chartsare typically restricted to a solitary data collection per chart. The individual slices of the pie are data markers and not a collection of data.


modify Individual Data mite

When you desire to call attention come a certain data marker, make it look various from the rest of the group. All you must do is readjust the formatting that the data marker.


change the shade of a single Column

The color of a single column in a column chart or a solitary point in a heat graph have the right to be readjusted without affecting the various other points in the series. A data marker the is a different color than the remainder of the group will pop the end on the chart.


Select a data series in a obelisk chart. All columns the the same shade are highlighted. Each tower is surrounding by a border the includes little dots on the corners.


*

*

When a graph is selected, the graph Tools appears in the ribbon and contains 2 tabs. The layout tab and also the style tab.


*

*

to mark Data through an Exploding Pie graph

Individual slices the a pie chart space usually different colors. So, emphasizing a single portion or data point needs a different method from columns and line charts. You have the right to highlight pie charts through exploding the end a single slice the pie indigenous the graph.


add Emphasis through a Combo graph

Another alternative for emphasizing different types of information in a chart is to screen two or more chart types in a solitary chart, such as a obelisk chart and also a heat graph. You could use this method when the graphed values vary extensively or as soon as graphing different types of data.

See more: What Do You Have To Wear Glasses For 3D Movies ? Why Do We Wear Glasses To View 3D Movies


A usual example is a climograph or climate graph, which combines precipitation and temperature data because that a single location ~ above one chart. Additionally, combination or combo charts are produced by plot one or more data collection on a an additional vertical or Y-axis.