Clustered Bar Chart Labels

[Alan Z. Scharf]

Is there a way to get the Y-axis data category labels on a horizontal
clustered bar chart to each display on two lines?

Some of my labels are longer than others and push the chart to far to the
right.

Readers of the report are insisting on the long labels.

There doesn't seem to be a way to highlight the Y-axis catagory labels and
drag them to a shape of 2 lines.

Thanks.

Alan

 

[Echo S]

Is there a way to get the Y-axis data category labels on a horizontal
clustered bar chart to each display on two lines?

Some of my labels are longer than others and push the chart to far to
the
right.

Readers of the report are insisting on the long labels.

There doesn't seem to be a way to highlight the Y-axis catagory labels and
drag them to a shape of 2 lines.

If you do the chart in Excel, you can put a line break (Alt+Enter) in there.
You can't drag the edges of the text area to resize, though.

I find it easiest to just do the labels by hand (using manual textboxes),
since neither PPT nor Excel really gives you much control over them.

 

[Alan Z. Scharf]

Echo,

Thanks for your reply.

Actually I'm doing it in MSGraph via linked dynamic table data, so it's not
subject to hand manipulation. The charts are used in a series of Access
reports.

I wrote my question in the PowerPoint group because I thought there was a
common feature of MSGraph/PowerPoint that was missing.
I guess not.

Maybe there is a way I can embed a line break in the category labels field
in the database and have MSGraph recognize them.

Alan

Is there a way to get the Y-axis data category labels on a horizontal
clustered bar chart to each display on two lines?

Some of my labels are longer than others and push the chart to far to
the
right.

Readers of the report are insisting on the long labels.

There doesn't seem to be a way to highlight the Y-axis catagory labels and
drag them to a shape of 2 lines.

If you do the chart in Excel, you can put a line break (Alt+Enter) in there.
You can't drag the edges of the text area to resize, though.

I find it easiest to just do the labels by hand (using manual textboxes),
since neither PPT nor Excel really gives you much control over them.

--
Echo [MS PPT MVP]
http://www.echosvoice.com
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/

 

[Echo S]

Good luck with it, Alan. I'm pretty sure MS Graph is the same for all the
applications except Excel.

Do the guys over on the Access groups have any ideas? I'd bet they run into
"no manual manipulation" more than we do here.

We used to be able to put line breaks in the category titles, so if you or
anyone else remembers doing this, no, you're not losing your mind! That was
back in PPT 95, though, and it's been broken ever since. <sigh>

--
Echo [MS PPT MVP]
http://www.echosvoice.com
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/

Echo,

Thanks for your reply.

Actually I'm doing it in MSGraph via linked dynamic table data, so it's
not
subject to hand manipulation. The charts are used in a series of Access
reports.

I wrote my question in the PowerPoint group because I thought there was a
common feature of MSGraph/PowerPoint that was missing.
I guess not.

Maybe there is a way I can embed a line break in the category labels field
in the database and have MSGraph recognize them.

Alan

Is there a way to get the Y-axis data category labels on a horizontal
clustered bar chart to each display on two lines?

Some of my labels are longer than others and push the chart to far to
the
right.

Readers of the report are insisting on the long labels.

There doesn't seem to be a way to highlight the Y-axis catagory labels and
drag them to a shape of 2 lines.

If you do the chart in Excel, you can put a line break (Alt+Enter) in there.
You can't drag the edges of the text area to resize, though.

I find it easiest to just do the labels by hand (using manual textboxes),
since neither PPT nor Excel really gives you much control over them.

--
Echo [MS PPT MVP]
http://www.echosvoice.com
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/