Style<\/h4>\n<\/li>\n<\/ul>\n
The user can use the option \u201cstyle\u201d to fine-tune the appearance and style of the chart.<\/p>\n
- \n
- \n
Color<\/h4>\n<\/li>\n<\/ul>\n
The user can use the option \u201ccolor\u201d to choose the color scheme for the chart and the changes can appear in the page layout tab also.<\/p>\n
Chart Filters<\/h4>\n
The user can use chart filters to edit the data values and data names that appear on the chart dynamically. To do so, follow the steps:<\/p>\n
1 – Click on the chart.<\/p>\n
2 – Select the Chart Filters icon which appears at the upper-right corner of the chart. The user can see two tabs namely values and names in a new window.<\/p>\n
Note: The series and the categories in the data are known as values. If you click on the values tab then the available series and categories will appear.<\/p>\n
Fine Tuning<\/h4>\n
The user can use the three buttons that appear at the upper-right corner of the chart to fine-tune the charts rapidly.<\/p>\n
The three buttons through which the user can fine-tune the chart are:<\/p>\n
- \n
- Chart Elements – The user can use the chart elements to add chart elements like axis titles or data labels.<\/li>\n
- Chart Styles – The user can use the chart styles to customize the look of the chart.<\/li>\n
- Chart Filters – The user can use the chart filters to change the data that appears on the chart.<\/li>\n<\/ul>\n
To view the fine-tuning elements, follow the steps:<\/p>\n
1 – Click on the chart and there the user can see the three buttons at the upper right corner of the chart.<\/p>\n
Format Style<\/h4>\n
The user can use Chart Styles to set a style for your chart.<\/p>\n
1 – Place the cursor on the Chart.<\/p>\n
2 – Click the \u201cChart Styles\u201d icon. The style and color option appears. The user can use the style option to fine-tune the appearance and style of the chart.<\/p>\n
3 – Click on the style option to look at the different styles available for the chart.<\/p>\n
4 – Scroll down the options and choose according to the preferences of your chart.<\/p>\n
Format Color<\/h4>\n
The user can use color in chart styles to select the color scheme for the chart.<\/p>\n
1 – Click on the Chart and choose the chart style icon.<\/p>\n
2 – Under the color option, click on the color from the different color scheme options.<\/p>\n
Excel Chart Filters<\/h4>\n
The user can use the chart filters to edit the data points, data values, and names that are visible on the chart being displayed, dynamically.<\/p>\n
1 – Click on the chart and choose the chart filter icon from the upper right corner of the chart.<\/p>\n
Note: The values and names appear in a new window.<\/p>\n
2 – Click on the values and the available series and categories appear in the data.<\/p>\n
3 – Select or deselect the series and categories.<\/p>\n
Note: The chart changes by displaying only the selected series and categories.<\/p>\n
4 – Click apply, after the final selection of series and categories.<\/p>\n
Excel Chart Elements<\/h4>\n
Chart elements give more descriptions to the charts and this helps in enhancing the data more meaningfully and also it helps in enriching the visual appearance of the data.<\/p>\n
To insert the chart elements in the chart, follow the steps below:<\/p>\n
1 \u2212 Select the chart. Three buttons appear at the upper-right corner of the chart. They are \u2212<\/p>\n
- \n
- The first symbol denotes the chart elements<\/li>\n
- The second symbol denotes the chart styles and colors<\/li>\n
- The third symbol denotes the chart filters<\/li>\n<\/ul>\n
![\"Excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/chart-elements.webp\")
<\/a><\/p>\n2 \u2212 Click on the first symbol, the chart element icon. The following chart elements are actually available in it.<\/p>\n
- \n
- Axes<\/li>\n
- Axis titles<\/li>\n
- Chart titles<\/li>\n
- Data labels<\/li>\n
- Data table<\/li>\n
- Error bars<\/li>\n
- Gridlines<\/li>\n
- Legend<\/li>\n
- Trendline<\/li>\n<\/ul>\n
<\/p>\n
The user can add, remove or change these chart elements.<\/p>\n
3 \u2212 Place the cursor on each of these chart elements to see a preview of how they are displayed.<\/p>\n
Note: For example, select Chart Title. The chart title in the graph will be highlighted.<\/p>\n
![\"excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/chart-title2.webp\")
<\/a><\/p>\n<\/p>\n
Note: A small arrow which is beside the chart elements is available to indicate that there are options available in it.<\/p>\n
![\"excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/chart-title.webp\")
<\/a><\/p>\n<\/p>\n
4 \u2212 Check mark on the chart elements boxes, which you want in the chart to be displayed.<\/p>\n
![\"excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/check-mark.webp\")
<\/a><\/p>\nAxes in Chart<\/h4>\n
A basic chart has two axes and they are used to measure and categorize the data. The two types of axes are<\/p>\n
- \n
- A vertical axis is also known as the value axis or y-axis.<\/li>\n
- A horizontal axis is also known as a category axis or x-axis.<\/li>\n<\/ul>\n
Note: A 3-D Column chart has a three-axis and the third axis is the depth axis which is also known as the series axis or the z-axis. There are some charts with no axes and those are pie and doughnut charts. The radar charts do not have horizontal axes.<\/p>\n
Excel Chart Axis Titles<\/h3>\n
The axis titles help the user to understand the chart and also the data.<\/p>\n
- \n
- The user can add axis titles to any horizontal, vertical, or depth axes in the chart.<\/li>\n
- The user cannot add axis titles to charts that do not have axes such as pie or doughnut charts.<\/li>\n<\/ul>\n
Chart Title<\/h3>\n
When the user creates a chart, a Chart Title box appears above the chart.<\/p>\n
Note: The user can also link the chart title to the cells containing text on the worksheet. When the text on the worksheet changes, automatically the chart title also changes.<\/p>\n
![\"excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/axis-and-title.webp\")
<\/a><\/p>\nData Labels<\/h3>\n
Data labels show the details about a data series. It makes the user understand the chart easier.<\/p>\n
Note<\/strong>: The user can change the location of the data labels within the chart.<\/p>\n
Data Table<\/h3>\n
The data table displays the table in the chart itself and it can be displayed in line, area, column and bar charts.
\nNote<\/strong>: The data table in the bar chart does not replace an axis whereas it is aligned to the chart.<\/p>\n![\"excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/data-table.webp\")
<\/a><\/p>\nError Bars<\/h3>\n
Error bars represent the potential error amounts relative to each data marker in a data series. The user can add Error bars to a data series in 2-D area chart, bar chart, column chart, line chart and bubble chart.<\/p>\n
Gridlines in excel<\/h3>\n
Gridlines are available to make the data easier and there are two types of gridlines and they are the horizontal and vertical chart gridlines.<\/p>\n
Gridlines can also extend from any horizontal and vertical axes across the plot area of the chart.<\/p>\n
The user can also display the depth gridlines in 3-D charts.<\/p>\n
Note: The user cannot display gridlines for the chart types that do not display axes.<\/p>\n
![\"gridlines](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/gridlines.webp\")
<\/a><\/p>\nLegend in excel<\/h3>\n
The Legend appears by default when the user creates a chart. The user can also hide a legend by deselecting it from the elements of the chart.<\/p>\n
![\"legend](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/legend.webp\")
<\/a><\/p>\nTrendline<\/h3>\n
Trendlines in the chart element are generally used to graphically display the trends in data series and to analyze the prediction problems. This type of analysis is also called regression analysis.<\/p>\n
Note: The user can extend a trendline in a chart beyond the actual data to predict the future values by using regression analysis.<\/p>\n
Design Tools<\/h4>\n
Chart tools consist of two tabs known as design and format tabs.<\/p>\n
Step 1 – When the user clicks on a chart, the chart tools appear on the ribbon under the design and format tab.<\/p>\n
Step 2 – Click on the \u201cDesign\u201d tab at the Ribbon. Then, the ribbon holds the commands from the design tab.<\/p>\n
![\"excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/chart-tool-ribbon.webp\")
<\/a><\/p>\n<\/p>\n
Some of the Design commands on the ribbon are:<\/p>\n
Chart layouts group<\/h4>\n
This command contains the Add chart element and quick layout options.<\/p>\n
Chart styles group<\/h4>\n
This command contains the change colors and chart styles options.<\/p>\n
Data group<\/h4>\n
This command contains the options such as switch row\/column and select data.<\/p>\n
Type group<\/h4>\n
This command contains the option such as Change chart type.<\/p>\n
Location group<\/h4>\n
This command contains the option such as Move chart.<\/p>\n
![\"design](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/design-tab-elements.webp\")
<\/a><\/p>\nAdd Chart Element<\/h4>\n
To add chart elements, follow the step:<\/p>\n
1 – Click on the Add Chart Element. The chart elements appear in a drop-down list and these are the same elements as those in the chart elements list.<\/p>\n
Change Colors<\/h4>\n
To change colors, click on the change colors option from the ribbon. The color schemes appear in a drop down listbox.<\/p>\n
Switch Row\/Column<\/h4>\n
The user can switch row\/column to change the data between X-axis and Y-axis.
\nClick on the Switch Row \/ Column option. The data will be exchanged between X-axis and Y-axis on the chart.<\/p>\nQuick Formatting in Excel<\/h4>\n
The user can format charts by using the Format pane. It is quite handy and provides advanced formatting options.<\/p>\n
To Format, any chart element, follow the steps:<\/p>\n
1 – Click on the chart and make a right-click on the chart element.<\/p>\n
2 – Select the Format option from the chart element drop-down list.<\/p>\n
Format Pane in Excel<\/h4>\n
By default, the formatting pane appears on the right side of the chart. To view the formatting pane, follow the steps:<\/p>\n
1 – Click on the chart and make a right-click on the horizontal axis.<\/p>\n
2 – The user can view the formatting pane and can select the options from the formatting pane.<\/p>\n
3 – If the user clicks on the option \u201cFormat Axis\u201d. Then the Format pane appears for the formatting axis.<\/p>\n
![\"excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/format-axis.webp\")
<\/a><\/p>\nQuick Layout<\/h4>\n
The user can use Quick Layout to change the overall layout of the chart by choosing any one of the predefined layout options. To apply a quick layout, follow the steps:<\/p>\n
1 – Choose \u201cQuick Layout\u201d from the ribbon.<\/p>\n
Note: Various predefined layout options will appear.<\/p>\n
2 – Place the cursor across the predefined layout options. The chart layout keeps changing as per the option chosen.<\/p>\n
3 – Select the layout as per the requirement. The chart appears with the chosen layout.<\/p>\n
![\"excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/quick-layout.webp\")
<\/a><\/p>\nChart Format Tools<\/h4>\n
When the user clicks on a chart, a new tab \u201cChart Tools\u201d appears above the tabs of \u201cDesign\u201d and \u201cFormat\u201d. Choose the format tab from the ribbon and the ribbon appears with the changes to format commands.<\/p>\n
![\"excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/format-ribbon-elements.webp\")
<\/a><\/p>\n<\/p>\n
The Ribbon contains the few format commands and they are:<\/p>\n
1. Current Selection Group<\/h4>\n
Under the current selection group, there are following options available and they are chart element selection box, format selection and reset to match style.<\/p>\n
2. Insert Shapes Group<\/h4>\n
Under the insert shapes group, there are following options available and they are different shapes to insert, change shape.<\/p>\n
3. Shape Styles Group<\/h4>\n
Under the shape styles group, the following options are available and they are shape styles, shape fill, shape outline, shape effects,<\/p>\n
4. WordArt Styles<\/h4>\n
Under the wordart styles, there are few following options available and they are wordart styles, text fill, text outline and text effects.<\/p>\n
5. Arrange Group<\/h4>\n
Under the arrange group, the following options are available and they are: bring forward, send backward, selection pane, align, group and rotate.<\/p>\n
6. Size Group<\/h4>\n
Under the size group there are two following options available and they are shape height, shape width.<\/p>\n
7. Current Selection Group<\/h4>\n
The user can format the chart elements using the current selection group commands.<\/p>\n
For formatting the charts through the Ribbon, follow the given steps.<\/p>\n
Step 1 – Select the chart element that the user wants to format. There appears a box at the top of the group.<\/p>\n
Step 2 – Click on the Format Selection and the format pane appears for the selected chart element.<\/p>\n
Step 3 – Using the options in the format pane, format the selected chart element.<\/p>\n
8. Insert Shapes Group<\/h4>\n
The user can insert different shapes in the chart selecting the shapes. After the user inserts a shape, they can add text to it by using the Edit Text.<\/p>\n
9. Shape Styles Group<\/h4>\n
- \n
- The user can change the style of the shape, choosing any of the given styles.<\/li>\n
- The user can choose a Shape Fill Color.<\/li>\n
- The user can Format Shape Outline.<\/li>\n
- The user can add Visual Effects to the Shape.<\/li>\n<\/ul>\n
10. WordArt Styles Group<\/h4>\n
- \n
- The user can use the word art to change the way the chart appears. The available options in the style group are:<\/li>\n
- Fill the text with a color using the Text Fill command.<\/li>\n
- Customize the Text Outline of the word.<\/li>\n
- Add visual effects to the text by utilizing the Text Effects.<\/li>\n<\/ul>\n
Arrange Group<\/h3>\n
To select the objects on the chart, change the order or visibility of the selected objects, the user uses the arrange group commands. Click on the selection pane command to look at the objects present on the chart. The selection pane displays the available objects on the chart.<\/p>\n
Select the objects and then the user can do the following on the selected objects:<\/p>\n
- \n
- Bring Forward<\/li>\n
- Send Backward<\/li>\n
- Selection Pane<\/li>\n
- Align<\/li>\n
- Group<\/li>\n
- Rotate<\/li>\n
- Size Group<\/li>\n<\/ul>\n
To change the width or the height of the shape or picture on the chart, the user uses the size group commands. The user can use the shape height box and shape width box to alter the height and weight respectively of a shape or picture on Excel.<\/p>\n
Format Data Series in excel<\/h3>\n
To format the data series, follow the steps<\/p>\n
1 – Right-click on any of the data series on the chart and then click the Format Data Series option.<\/p>\n
2 – Choose the required Series Options.<\/p>\n
The user can edit the display of the series through these options.<\/p>\n
![\"excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/format-data-series.webp\")
<\/a><\/p>\nFormat Data Labels<\/h4>\n
To format data labels quickly, follow the steps \u2212<\/p>\n
1 – Right-click on a data label. The data labels of the entire series are chosen and then click on the format data labels.<\/p>\n
2 – Select the Label options as per the requirement.<\/p>\n
The user can edit the display of the data labels of the selected series through the following options.<\/p>\n
![\"excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/format-data-labels.webp\")
<\/a><\/p>\nFormat Data Point<\/h4>\n
To format the data point in your line chart, follow the steps<\/p>\n
1 – Click on the data point and then the entire series is selected.<\/p>\n
2 – Click on the data point again so that only a particular data point is selected together.<\/p>\n
3 – Right-click that particular selected data point and then click on the \u201cFormat Data Point\u201d option.<\/p>\n
4 – Select the required Series Options and then the user can edit the display of the data points from the options.<\/p>\n
![\"Excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/format-data-point.webp\")
<\/a><\/p>\nFormat Legend<\/h4>\n
To format Legend, follow the steps:<\/p>\n
1 – Right-click on the legend option and select Format Legend.<\/p>\n
2 – Choose the required Legend Options and the user can edit the display of the legends through these options.<\/p>\n
![\"excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/format-legend.webp\")
<\/a><\/p>\nFormat Major Gridlines<\/h4>\n
To format major gridlines of the chart, follow the steps:<\/p>\n
1 – Right-click on the major gridlines and then choose \u201cFormat Gridlines\u201d.<\/p>\n
![\"excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/format-gridlines.webp\")
<\/a><\/p>\nData Label Positions<\/h4>\n
To place the data labels inside the chart, follow the steps:<\/p>\n
1 – Click on the chart and then select chart elements.<\/p>\n
2 – Select Data Labels and click the arrow mark beside the data label to view the other options available.<\/p>\n
3 – Click on the option \u201cCenter\u201d to place the data labels at the center.<\/p>\n