What is the advantage of using a "Chart Title" object over just another text box?

[Taylor]

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?

 

[Taylor]

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.

 

[ShaneDevenshire]

Personally I thing there is little or no advantage. If you're in the chart
wizard the titles are all in one place, not a big deal.

 

[Del Cotter]

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.

 

[Jon Peltier]

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
_______

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
(e-mail address removed),
which goes to a spam folder-- please send your email to del3 instead.

 

[Del Cotter]

[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?

Go ahead. It would be great if my daydreams of what Excel charts, or a
hypothetical other chart-from-spreadsheet application, would look like
were to become reality.

Now I come to think of it, Jon is one of those people who doesn't have
to just write to wish lists. He has a number of charting add-ins on his
site, so maybe he has in mind actually implementing the above.

Jon, if so, may I add a wish not directed at MS? Each one of those
add-ins is separate at the moment. Have you thought of bundling them
into one big application with a chart-choosing menu?

 

[Jon Peltier]

[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?

Go ahead. It would be great if my daydreams of what Excel charts, or a
hypothetical other chart-from-spreadsheet application, would look like
were to become reality.

Now I come to think of it, Jon is one of those people who doesn't have to
just write to wish lists. He has a number of charting add-ins on his site,
so maybe he has in mind actually implementing the above.

Jon, if so, may I add a wish not directed at MS? Each one of those
add-ins is separate at the moment. Have you thought of bundling them into
one big application with a chart-choosing menu?

Del -

I'm planning just that approach. Unfortunately it's a nights-and-weekends
kind of effort, so I'm making only very slow progress. It's taken me so long
to do this that now I have to worry about making everything compatible with
2007.

Your data layout is a nice way to add chart titles and other annotations to
a chart. I've spent a lot of effort on the routine parts of the data range,
including parsing out of series names, category labels, etc., and the chart
title and reference label add a lot with very little user effort.

- Jon