Chart Design Tab

The Chart Design tab is a collection of icons for various commands that are used to create and edit charts. You can design the chart style, axis, legend display options with the features in the Chart Design tab.

More Information

Chart Design Tab

Type - Change Chart Type

Bar In the bar chart style image collection, select the desired style to apply to the chart.
Column In the column chart style image collection, select the desired style to apply to the chart.
Line/Area In the line/area chart style image collection, select the desired style to apply to the chart.
Pie In the circle chart style image collection, select the desired style to apply to the chart.
Scatter In the scatter chart style image collection, select the desired style to apply to the chart.
Others In the chart style image collection, select the desired style among stock, radar, or surface chart.

Layout

Add Chart Element Axis Specify whether to display primary horizontal/vertical and secondary horizontal/vertical axis or not.
  • Primary Horizontal: Display the primary horizontal axis.
  • Primary Vertical: Display the primary vertical axis.
Axis Titles Specify position for axis title.
  • Primary Horizontal: Display the axis title at the bottom of the chart.
  • Primary Vertical: Display the axis title on the left of the chart.
Chart Title Specify whether to display chart title, and its position.
  • None: Do not display the chart title.
  • Above Chart: Display the chart title at the top of the chart.
  • Centered Overlay: Overlap the chart title and chart.
Data Labels Specify whether to display data labels.
  • None: Do not display data labels.
  • Show: Display data labels.
Gridlines Display primary major horizontal/vertical and minor horizontal/vertical gridlines.
  • Primary Major Horizontal: Display primary major horizontal gridlines.
  • Primary Major Vertical: Display primary major vertical gridlines.
  • Primary Minor Horizontal: Display primary minor horizontal gridlines.
  • Primary Minor Vertical: Display primary minor vertical gridlines.
Legend Specify position for a chart legend.
  • None: Do not display the legend.
  • Right: Display the legend on the right.
  • Top: Display the legend at the top.
  • Left: Display the legend on the left.
  • Bottom: Display the legend at the bottom.
Trendline Add trendlines to depict specific flows and general trends in data.
  • None: Do not display the trendline.
  • Linear: Display data flows in a straight line. This trendline is recommended to use if data values continuously increase or decrease over time.
  • Exponential: Display data flows in a curved line. This trendline is recommended to use if data values rise or fall at increasingly higher rates. However, this trendline cannot be applied to a chart containing zero or negative values.
  • Linear Forecast: Predict how the data will changes by moving the data elements forward two sections. In the Trendline Properties tab of the Object Properties task pane, change Forecast to predict the flows.
  • Moving Average: Calculate average value of the data within a specific period and display trendline based on it. The default period is set as “2”.
  • Trendline Properties: Open the Trendline Properties tab of the Object Properties task pane to change trendline properties.
Error Bars Add an error bar to display the amount of error (deviation) for each data value.
  • None: Do not display the error bar.
  • Standard Error: Apply error bars to fit the standard error category. The basic value is set to calculate the standard error value so it allows to display error bars simply.
  • Percentage: Display error bars with percentages based on individual data.
  • Standard Deviation: Display error bars based on the standard deviation. The error bars in the same length are on the mean place of the chart to visualize how far those error bars are from the data points.
  • Error Bars Properties: Open the Error Bars Properties tab of the Object Properties task pane to change error bars properties.
Lines Add some lines such as drop lines and series lines to clarify data points.
  • None: Do not display additional lines such as drop lines or high-low lines.
  • Drop Lines: Add a descending line that drops from the marker point to the x-axis.
  • Series Lines: Display series lines on a stacked chart to compare or track flows in each item.
  • High-Low Lines: Add high-low lines that connect the highest value and the lowest value in a stock chart.
  • Drop High-Low Lines: Add drop lines and high-low lines that connect the highest value and the lowest value in a stock chart.
Up/Down Bars Add up/down bars which mean rise or drop of stock prices in a stock chart.
  • None: Do not display the up/down bars.
  • Up/Down Bars: Add up/down bars in a stock chart.
  • Up/Down Bars Properties: Open the Up/Down Bars Properties tab of the Object Properties task pane to change up/down bars properties.
Chart Layout Provides a chart layout collection that incorporates various chart components such as axis, chart title, data labels and more.

Series Color

Colorful Select a color to apply to chart series.
Monochromatic Select a monochromatic color to apply to chart series.

Chart Styles

Chart Templates Provides a chart style image collection that incorporates properties such as fill, line, shadow and more.

Data

Switch Row/Column Switch row data and column data of the selected chart.
Edit Chart Data Show the Edit Chart Data dialog box to edit the data of the selected chart.

See Also