The names of the series and the names of the categories in the chart will be displayed. Click the NAMES tab in the Chart Filters. You can change the names of the series in the chart using the names tab in the chart filters. By default, names are taken from the excel table. NAMES represent the names of the series in the chart. Only the selected categories will be displayed on the chart. Step 2 − Select the category you want to display deselect the rest of the categories. In addition, the data corresponding to that category will be highlighted in the excel table. That particular category will be highlighted on the chart. Step 1 − Point to any of the available categories. Only the selected series will be displayed on the chart. Step 2 − Select the series you want to display and deselect the rest of the series. In addition, the data corresponding to that series will be highlighted in the excel table. That particular series will be highlighted on the chart. Step 1 − Point on any of the available series. The available SERIES and CATEGORIES in your data appear. Values are the series and the categories in the data.Ĭlick the Values tab. Two tabs – VALUES and NAMES appear in a new window. Step 2 − Click the Chart Filters icon that appears at the upper-right corner of the chart. You can use Chart Filters to edit the data points (values) and names that are visible on the displayed chart, dynamically.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |