I had an email exchange with Charley Kyd tonight, and I was bemoaning the fact that I couldn't link my Excel chart titles to a range. I could have sworn you could do this, but not working with charts a ton, I just could not find a way to do this in the Excel 2010 user interface.
To me, the logical place for this kind of functionality would be in the "Select Data Source" userform. This would seem a no-brainer since it's where you link up your series, define your chart range and axis labels as well as your legend. Why wouldn't you be able to link your title here if it was possible?
Well, apparently, just because it isn't in a wizard or a userform doesn't mean it can't be doneâ€¦ and done without resorting to VBA.
What I was looking for specifically was to give the following chart a dynamic title.
The data in the table is dynamic, and reflect the product line. So depending on a data validation list, I could be showing Beer, Wine or Liquor sales. Based on what Charley told me, I set up a little matrix under the chart:
- Select the chart title
- Press =
- Click on the cell that contains my new dynamic title
And likewise when I change it to reflect Beer:
So am I the only person who didn't know this? It's not really that intuitive is it? (Thanks for the pointer, Charley!)