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.


On Feb 23, 12:18 pm, "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?

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.

--
Cheers,
Shane Devenshire


"Taylor" wrote:

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.


On Feb 23, 12:18 pm, "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?

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.

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.

On Sun, 25 Feb 2007, in microsoft.public.excel.charting,
Jon Peltier said:
[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 Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

"Del Cotter" wrote in message
...
On Sun, 25 Feb 2007, in microsoft.public.excel.charting,
Jon Peltier said:
[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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______