Stacked Bar Chart

I have a stacked column chart with 9 series for columns, one series for the
data labels (I have several charts stacked on top of one another) and a
bunch of text boxes. I am unable to change the font format for some of the
text boxes. It looks strange with some in one font and some in another.

You should be able to right click on the text boxes, and go to options or
format text boxes. Then there should be a place to change the font from a
tab. If not there should be another button that allows you to go to format or
settings. Going through there, you should find the place to change the font.
I hope this works.

"Barb Reinhardt" wrote:

> I have a stacked column chart with 9 series for columns, one series for the
> data labels (I have several charts stacked on top of one another) and a
> bunch of text boxes. I am unable to change the font format for some of the
> text boxes. It looks strange with some in one font and some in another.
>
>
>

I already tried several methods to change the font, including the ones you
suggested and none worked. I ended up putting in new text boxes after the
chart was formatted with the font I wanted, but I shouldn't have had to do
that.

"Rami" <Rami@discussions.microsoft.com> wrote in message
news:BF2C86C8-85B9-4033-A064-0A6FBF0BFD99@microsoft.com...
> You should be able to right click on the text boxes, and go to options or
> format text boxes. Then there should be a place to change the font from a
> tab. If not there should be another button that allows you to go to format
or
> settings. Going through there, you should find the place to change the
font.
> I hope this works.
>
> "Barb Reinhardt" wrote:
>
> > I have a stacked column chart with 9 series for columns, one series for
the
> > data labels (I have several charts stacked on top of one another) and a
> > bunch of text boxes. I am unable to change the font format for some of
the
> > text boxes. It looks strange with some in one font and some in
another.
> >
> >
> >

My graphs are a more complicated version of this:

http://peltiertech.com/Excel/Charts/axes.html#StakCht

"Rami" <Rami@discussions.microsoft.com> wrote in message
news:BF2C86C8-85B9-4033-A064-0A6FBF0BFD99@microsoft.com...
> You should be able to right click on the text boxes, and go to options or
> format text boxes. Then there should be a place to change the font from a
> tab. If not there should be another button that allows you to go to format
or
> settings. Going through there, you should find the place to change the
font.
> I hope this works.
>
> "Barb Reinhardt" wrote:
>
> > I have a stacked column chart with 9 series for columns, one series for
the
> > data labels (I have several charts stacked on top of one another) and a
> > bunch of text boxes. I am unable to change the font format for some of
the
> > text boxes. It looks strange with some in one font and some in
another.
> >
> >
> >

Barb -

Is the text rather small? Sometimes if you ask for a small font, say 5 or 6 points,
it actually changes to the desired font, and prints accurately, but doesn't appear
to on screen.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Barb Reinhardt wrote:

> I already tried several methods to change the font, including the ones you
> suggested and none worked. I ended up putting in new text boxes after the
> chart was formatted with the font I wanted, but I shouldn't have had to do
> that.
>
> "Rami" <Rami@discussions.microsoft.com> wrote in message
> news:BF2C86C8-85B9-4033-A064-0A6FBF0BFD99@microsoft.com...
>
>>You should be able to right click on the text boxes, and go to options or
>>format text boxes. Then there should be a place to change the font from a
>>tab. If not there should be another button that allows you to go to format
>
> or
>
>>settings. Going through there, you should find the place to change the
>
> font.
>
>>I hope this works.
>>
>>"Barb Reinhardt" wrote:
>>
>>
>>>I have a stacked column chart with 9 series for columns, one series for
>
> the
>
>>>data labels (I have several charts stacked on top of one another) and a
>>>bunch of text boxes. I am unable to change the font format for some of
>
> the
>
>>>text boxes. It looks strange with some in one font and some in
>
> another.
>
>>>
>>>
>
>

No, the font was at least 10 point and maybe larger. I didn't try to print
it to see if it rendered properly. This graph is for a report which *may*
be delivered electronically as well as in a print version so it has to look
right on the screen as well. I'm thinking that Excel was reaching it's
limit of data on the chart or in the workbook (I have lots of worksheets).

"Jon Peltier" <jonREMOVExlmvp@peltierCAPStech.com> wrote in message
news:uO2XsxY3EHA.2288@TK2MSFTNGP11.phx.gbl...
> Barb -
>
> Is the text rather small? Sometimes if you ask for a small font, say 5 or
6 points,
> it actually changes to the desired font, and prints accurately, but
doesn't appear
> to on screen.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> Barb Reinhardt wrote:
>
> > I already tried several methods to change the font, including the ones
you
> > suggested and none worked. I ended up putting in new text boxes after
the
> > chart was formatted with the font I wanted, but I shouldn't have had to
do
> > that.
> >
> > "Rami" <Rami@discussions.microsoft.com> wrote in message
> > news:BF2C86C8-85B9-4033-A064-0A6FBF0BFD99@microsoft.com...
> >
> >>You should be able to right click on the text boxes, and go to options
or
> >>format text boxes. Then there should be a place to change the font from
a
> >>tab. If not there should be another button that allows you to go to
format
> >
> > or
> >
> >>settings. Going through there, you should find the place to change the
> >
> > font.
> >
> >>I hope this works.
> >>
> >>"Barb Reinhardt" wrote:
> >>
> >>
> >>>I have a stacked column chart with 9 series for columns, one series for
> >
> > the
> >
> >>>data labels (I have several charts stacked on top of one another) and a
> >>>bunch of text boxes. I am unable to change the font format for some
of
> >
> > the
> >
> >>>text boxes. It looks strange with some in one font and some in
> >
> > another.
> >
> >>>
> >>>
> >
> >
>

Was the sheet at 100% zoom?

Other settings can sometimes cause problems.

Barb Reinhardt wrote:
> No, the font was at least 10 point and maybe larger. I didn't try to print
> it to see if it rendered properly. This graph is for a report which *may*
> be delivered electronically as well as in a print version so it has to look
> right on the screen as well. I'm thinking that Excel was reaching it's
> limit of data on the chart or in the workbook (I have lots of worksheets).
>
> "Jon Peltier" <jonREMOVExlmvp@peltierCAPStech.com> wrote in message
> news:uO2XsxY3EHA.2288@TK2MSFTNGP11.phx.gbl...
>
>>Barb -
>>
>>Is the text rather small? Sometimes if you ask for a small font, say 5 or
>
> 6 points,
>
>>it actually changes to the desired font, and prints accurately, but
>
> doesn't appear
>
>>to on screen.
>>
>>- Jon
>>-------
>>Jon Peltier, Microsoft Excel MVP
>>Peltier Technical Services
>>Tutorials and Custom Solutions
>>http://PeltierTech.com/
>>_______
>>
>>Barb Reinhardt wrote:
>>
>>
>>>I already tried several methods to change the font, including the ones
>>
> you
>
>>>suggested and none worked. I ended up putting in new text boxes after
>>
> the
>
>>>chart was formatted with the font I wanted, but I shouldn't have had to
>>
> do
>
>>>that.
>>>
>>>"Rami" <Rami@discussions.microsoft.com> wrote in message
>>>news:BF2C86C8-85B9-4033-A064-0A6FBF0BFD99@microsoft.com...
>>>
>>>
>>>>You should be able to right click on the text boxes, and go to options
>>>
> or
>
>>>>format text boxes. Then there should be a place to change the font from
>>>
> a
>
>>>>tab. If not there should be another button that allows you to go to
>>>
> format
>
>>>or
>>>
>>>
>>>>settings. Going through there, you should find the place to change the
>>>
>>>font.
>>>
>>>
>>>>I hope this works.
>>>>
>>>>"Barb Reinhardt" wrote:
>>>>
>>>>
>>>>
>>>>>I have a stacked column chart with 9 series for columns, one series for
>>>>
>>>the
>>>
>>>
>>>>>data labels (I have several charts stacked on top of one another) and a
>>>>>bunch of text boxes. I am unable to change the font format for some
>>>>
> of
>
>>>the
>>>
>>>
>>>>>text boxes. It looks strange with some in one font and some in
>>>>
>>>another.
>>>
>>>
>>>>>
>>>
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

These old eyes aren't as good as they once were, so I have it zoomed as much
as I can to still see the picture.

"Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
news:41B857CB.8050405@contexturesXSPAM.com...
> Was the sheet at 100% zoom?
>
> Other settings can sometimes cause problems.
>
> Barb Reinhardt wrote:
> > No, the font was at least 10 point and maybe larger. I didn't try to
print
> > it to see if it rendered properly. This graph is for a report which
*may*
> > be delivered electronically as well as in a print version so it has to
look
> > right on the screen as well. I'm thinking that Excel was reaching it's
> > limit of data on the chart or in the workbook (I have lots of
worksheets).
> >
> > "Jon Peltier" <jonREMOVExlmvp@peltierCAPStech.com> wrote in message
> > news:uO2XsxY3EHA.2288@TK2MSFTNGP11.phx.gbl...
> >
> >>Barb -
> >>
> >>Is the text rather small? Sometimes if you ask for a small font, say 5
or
> >
> > 6 points,
> >
> >>it actually changes to the desired font, and prints accurately, but
> >
> > doesn't appear
> >
> >>to on screen.
> >>
> >>- Jon
> >>-------
> >>Jon Peltier, Microsoft Excel MVP
> >>Peltier Technical Services
> >>Tutorials and Custom Solutions
> >>http://PeltierTech.com/
> >>_______
> >>
> >>Barb Reinhardt wrote:
> >>
> >>
> >>>I already tried several methods to change the font, including the ones
> >>
> > you
> >
> >>>suggested and none worked. I ended up putting in new text boxes after
> >>
> > the
> >
> >>>chart was formatted with the font I wanted, but I shouldn't have had to
> >>
> > do
> >
> >>>that.
> >>>
> >>>"Rami" <Rami@discussions.microsoft.com> wrote in message
> >>>news:BF2C86C8-85B9-4033-A064-0A6FBF0BFD99@microsoft.com...
> >>>
> >>>
> >>>>You should be able to right click on the text boxes, and go to options
> >>>
> > or
> >
> >>>>format text boxes. Then there should be a place to change the font
from
> >>>
> > a
> >
> >>>>tab. If not there should be another button that allows you to go to
> >>>
> > format
> >
> >>>or
> >>>
> >>>
> >>>>settings. Going through there, you should find the place to change the
> >>>
> >>>font.
> >>>
> >>>
> >>>>I hope this works.
> >>>>
> >>>>"Barb Reinhardt" wrote:
> >>>>
> >>>>
> >>>>
> >>>>>I have a stacked column chart with 9 series for columns, one series
for
> >>>>
> >>>the
> >>>
> >>>
> >>>>>data labels (I have several charts stacked on top of one another) and
a
> >>>>>bunch of text boxes. I am unable to change the font format for some
> >>>>
> > of
> >
> >>>the
> >>>
> >>>
> >>>>>text boxes. It looks strange with some in one font and some in
> >>>>
> >>>another.
> >>>
> >>>
> >>>>>
> >>>
> >
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>