, ,

69. Charts: Pivot Chart

Pivot charts are used to graphically summarize the data and explore complicated data.A Pivot chart shows the data series, categories, and chart axes the same way a standard chart does. Additionally, it also gives you interactive filtering…
, ,

68. Charts: Sparklines

Sparklines are tiny charts placed in single cells, each representing a row of data in your selection. They provide a quick way to see trends.Sparklines have the following types −Line Sparkline Column Sparkline Win/Loss SparklineIn…
, ,

67. Chart Tools

CHART TOOLS menu comprises of two tabs DESIGN and FORMAT.When you click on a chart, a new tab CHART TOOLS comprising of DESIGN and FORMAT tabs appear on the Ribbon.Click the FORMAT tab on the Ribbon. The Ribbon changes to the FORMAT…
, ,

66. Charts: Data Labels

You can have aesthetic and meaningful data labels. You can −Include rich and refreshable text from data points or any other text in your data labels. Enhance them with formatting and additional freeform text. Display them in just…
, ,

65. Formatting Charts

You can format charts quickly using the Format pane. It is quite handy and provides advanced formatting options.To Format any chart element,Step 1 − Click on the chart.Step 2 − Right-click chart element.Step 3 − Click…
, ,

64. Charts: Design Tools

Chart tools comprise of two tabs DESIGN and FORMAT.Step 1 − When you click on a chart, CHART TOOLS comprising of DESIGN and FORMAT tabs appear on the Ribbon.Step 2 − Click the DESIGN tab on the Ribbon. The Ribbon changes to…
, ,

63. Fine Tuning the charts

To fine tune the charts quickly, use the three buttons that appear at the upper-right corner of the chart.The three buttons through which you can fine-tune your chart quickly are − Chart Elements − To add chart elements like axis…
, ,

62. Chart Filters

You can use Chart Filters to edit the data points (values) and names that are visible on the displayed chart, dynamically.Step 1 − Click on the chart.Step 2 − Click the  Chart Filters icon that appears at the upper-right corner…
, ,

61. Chart Styles

You can use Chart Styles to customize the look of the chart. You can set a style and color scheme for your chart with the help of this tool.Follow the steps given below to add style and color to your chart.Step 1 − Click on the chart.…
, ,

60. Chart Elements

Chart elements give more descriptions to your charts, thus making your data more meaningful and visually appealing. In this chapter, you will learn about the chart elements.Follow the steps given below to insert the chart elements in your…