Del -
[Title]
[X label][1st series label][2nd series label etc.]
[X data][1st series data][2nd series data etc.]
[...]
[X data][1st series data][2nd series data etc.]
[Reference to source of data]
That's good. Mind if I steal it?
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Del Cotter" wrote in message
...
On Fri, 23 Feb 2007, in microsoft.public.excel.charting,
Taylor said:
"Taylor" wrote:
It kind of drives me nuts that I can't expand the box that the chart
title is in, which is a trick I use sometimes to make sure text in a
text box is centered precisely (center alignment, text box expanded
horizontally to the width of the chart).
Is it easier to access programatically, or where is the percentage
here?
Additionally, I note that while you can use nudge (and other drawing
functions) on a text box, you cannot do this on a chart title.
Also, when you save a custom-formatted chart type, the title is part of
the chart type, and not accessible to the new data you assign the format
to (who ordered *that*?)
MS chart wizards respond to a selected block of cells as follows..
[blank][1st series label][2nd series label etc.]
[X data][1st series data][2nd series data etc.]
[...]
[X data][1st series data][2nd series data etc.]
..and if there is only one series, it gives the title as that series
name, otherwise there is no title. In a better world, or a charting
application written by anyone rash enough to risk being stomped by the
Microsoft giant, chart wizards would respond to a selected block of
cells as follows:
[Title]
[X label][1st series label][2nd series label etc.]
[X data][1st series data][2nd series data etc.]
[...]
[X data][1st series data][2nd series data etc.]
[Reference to source of data]
The text at the top would be interpreted as the chart title. The text at
the bottom would appear in a text box near the bottom of the chart, in
small text, to be used to explain where the data came from. Also, the
X-series would be capable of being safely labelled without making the
chart wizard interpret it as a data series.
--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.