limitations to charting functionality
 

I wonder if anyone has some work-arounds for some of Excel's more annoying
limitations 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?

limitations to charting functionality
 

(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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Allen_N" wrote in message
...
I wonder if anyone has some work-arounds for some of Excel's more annoying
limitations 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?