![]() You can only select one Legend (Series) field, but you can select more than one field from the Values (Y axis) or Axis (Category) sections.At a minimum, select at least one Axis (Category) and one Values (Y axis) field.Notes Different field combinations are possible, but consider the following: All selected Values (Y axis) fields must either be aggregated or nonaggregated. Note Text fields must use the Count aggregation. To change the aggregation, click the down-arrow, and select from the list, including None to remove the aggregation. For all other fields, the default aggregation is Count. For numeric and currency fields, the default aggregation is Sum. The Values (Y axis) fields become the legend by default.īy default, each selected field is aggregated. When you select two or more Values (Y axis) fields, you can’t select a Legend (Series) field. This chart dimension shows vertical values in an XY chart layout in a clustered column and line chart, and horizontal values in a clustered bar chart.Įach field you select corresponds to a data series. Values (Y axis) Under this section, select one or more fields.For example, values in a State field are transposed as column headings and each becomes a separate data series. This chart dimension pivots field values into column headings. Legend (Series) Under this section, select a field.When you select more than one Axis (Category) field, it creates a hierarchy of tick marks along the dimension line (such as States within a Division). ![]() To change it, click the down arrow and select from the list, including None to remove the aggregation. The default aggregation of a date field is Months. This chart dimension shows horizontal values in an XY chart layout in a clustered column and line chart, and vertical values in a clustered bar chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |