» Showing or Hiding a data table or chart legend

The legend appears by default when a chart is created but one can hide or change its location after the chart has been created.
One can even show the data table for an area chart, line chart, column chart or a bar chart. These data table help in displaying the values that are present in the [...]

» Selecting individual Chart elements on the chart

The mouse can be used to select individual chart elements that are displayed in the chart like the chart area. In case you do not know the location of the element that has to be selected you can also select it from the chart element’s list. The keyboard can also be used to select the [...]

» Modifying the Chart Legend Entries

One can modify the legend entries by editing the corresponding data on the worksheet. For modifying or editing the legend entries without letting the worksheet data get affected, one can make changes through Select data source dialog box.
Editing the legend entries on the worksheet
1.Click on the cell on the worksheet that has the name of [...]

» Editing the Titles or Data labels in charts

This applies to Word, Outlook, Power Point and Microsoft Office Excel 2007.
One can edit the contents of the axis titles as well as the data labels in a chart. It can be changed for those that are not linked to any corresponding cell as well as those which are linked to the corresponding cells. The [...]

» Displaying or Hiding the Data label leader in Pie charts

This applies to Outlook, Word, Power Point and Microsoft Office Excel 2007
Leader points are shown for the data labels that are from the data points. This happens by default. Leader lines are used to illustrate the connection between the data label and the related data point. One can change their color and style and hide [...]

» Displaying & Hiding Chart Grid lines

For making the data in a chart having axes easier to read, the horizontal and vertical chart grid lines must be displayed. These grid lines extend from the horizontal and vertical axes across the plot area of the chart. The depth grid lines can be shown in the 3D charts. In case of charts having [...]

» Changing the Placement of Titles in a Chart

This applies to Word, Outlook, Power Point and Microsoft Office Excel 2007
For avoiding space constraints that can result due to long charts or even axis titles one can change the way these are positioned on the Chart. You can either choose a particular position where you want to place them or you can move them [...]