Chart Date Deed For Free

Titling the Graph The proper form for a graph title is "y-axis variable vs. x-axis variable." For example, if you were comparing the the amount of fertilizer to how much a plant grew, the amount of fertilizer would be the independent, or x-axis variable and the growth would be the dependent, or y-axis variable.

You can't use formula in chart title, but you can link it with a cell having a formula. If you want to enter a line break in chart title you can create that line break in the cell you are linking to.

The ChartTitle is a content control placed at the top of each chart control. It is used to display any title information regarding the visualized chart.

In the chart, right-click the category axis, and then click Format Axis. In the Format Axis pane, select the Axis Options tab. Expand Axis Options, and then under Axis Type, make sure Date axis is selected. Under Units, next to Base, select Days, Months, or Years.

Click the chart, and then click the Chart Design tab. Click Add Chart Element > Chart Title, and then click the title option that you want. Type the title in the Chart Title box. To format the title, select the text in the title box, and then on the Home tab, under Font, select the formatting that you want.

To easily update a chart or axis title, label, or text box that you have added to a chart, you can link it to a worksheet cell. Changes that you make to the data in that worksheet cell will automatically appear in the chart.

Follow these steps:Select the cells you want to format.Press CTRL+1.In the Format Cells box, click the Number tab.In the Category list, click Date.Under Type, pick a date format.If you want to use a date format according to how another language displays dates, choose the language in Locale (location).