Is is possible to use functions within charts (for example, if the
chart title changes based on the value in a cell)? That way, if the
chart data changes, the title also changes to reflect that.
Any ideas?
Yes it is. This is from Microsoft's support site:
To easily update a chart or axis title (titles in charts: Descriptive
text that is automatically aligned to an axis or centered at the top
of a chart.), label, or text box that you have added to a chart, you
can link it to a worksheet cell by creating a reference to that
worksheet cell. Changes that you make to the worksheet cell will
automatically appear in the chart.
On a chart sheet (chart sheet: A sheet in a workbook that contains
only a chart. A chart sheet is beneficial when you want to view a
chart or a PivotChart report separately from worksheet data or a
PivotTable report.) or in an embedded chart (embedded chart: A chart
that is placed on a worksheet rather than on a separate chart sheet.
Embedded charts are beneficial when you want to view or print a chart
or a PivotChart report with its source data or other information in a
worksheet.), click the title, label, or text box that you want to link
to a worksheet cell.
In the formula bar (formula bar: A bar at the top of the Excel window
that you use to enter or edit values or formulas in cells or charts.
Displays the constant value or formula stored in the active cell.),
type an equal sign (=).
Select the worksheet cell that contains the data or text that you want
to display in the chart.
If you want to type the reference to the worksheet cell, include the
sheet name followed by an exclamation point, for example, Sheet1!F2
Press ENTER.
+=+=+=+=+=+=+=+
As far as I know, you can only use a link to a single cell as a chart
title, not a full formula with functions etc. However, it would be
easy enough to use a worksheet cell to contain the formula you want,
and link the chart title to that.
