You can enter and modify the chart settings according to your preferences:
1.Select the chart you want to change the settings of.
2.On the Toolbar, click the (Chart Options). Or use the context menu. Or on the Command menu, click Format > Chart.
3.In the window that opens, enter or modify the following chart settings:
•Chart name (Title)
•Date series (Columns or Rows)
•Labels (In the first column and/or In the first row).