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.


Posted by: Jethro | 8:58 PM |