limitations to charting functionality

[Allen_N]

I wonder if anyone has some work-arounds for some of Excel's more annoying
limitations re: charts.

(1) It seems that the Title text box cannot be resized manually, even though
the usual 8 grab handles appear on the fuzzy border when the Title is
selected.

(2) There seems to be no way to attach additional text data to a chart (eg.
explanatory information or a formula).

Both of these features (and many more) are available in serious applications
like SigmaPlot, and it seems odd that Microsoft can keep releasing new
versions of Excel without addressing such obvious oversights. Am I missing
something?

 

[Jon Peltier]

(1) Replace the title with a text box.
(2) Add a text box or other shape.

When adding any shape (including a text box) to a chart, make sure you
select the chart first, then select the drawing tool, to make sure the shape
is part of the chart, and not just floating in the drawing layer with it.

- Jon