Wednesday, December 13, 2006

Linking Cells to Chart Titles

When you create a chart in Excel you have the option to type in the Chart title and X and Y Axis titles. Once you have created these, you can select them, then click in the formula bar, delete the text you previously entered, and then either type or select a cell reference. This will allow you to dynamically change the chart and axis titles based on what is in the linked cells.

This is very useful if you have a chart that is used for several different data sets, and using a drop down box or similar to select the data set. This can also be used to change the title of the chart at the same time using this technique.