Font Size for Values in Charts

#1 05-26-2005, 06:15 PM

Hello!
I'm creating very simplistic charts showing just one value. Example: a
pie chart showing 97% satisfaction. The 3% will be there but I deleted
the text showing the value.

My desire is to showcase the 97% - the document will be printed as an
11x17 poster, but I'm doing it in excel b/c we are creating multiple
sheets for multiple posters.

The problem is that I can't make the 97% any larger than 24 pt. font
without the % sign going on a second line. I would like to make the
font 48 pt or larger.

Also, I can not put the 97% in a text box on top of the chart b/c it's
linked to a data sheet and we'll be creating multiple sheets from this
'template'.

Does anyone know how I can achieve a larger font within the chart? I'm
working with XP Professional - 2003 Excel.

Thank you!
~Jaci

#2 05-27-2005, 05:05 PM

Jaci -

You can link a textbox to a cell, too. Select the chart, type the equals
key, and click on the cell. You should see the link address in the
formula bar, e.g., =Sheet1!$A$1. Press Enter and a textbox appears in
the middle of the chart; drag it to where you need it and make it as
large as you like.

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

Jaci wrote:
> Hello!
> I'm creating very simplistic charts showing just one value. Example: a
> pie chart showing 97% satisfaction. The 3% will be there but I deleted
> the text showing the value.
>
> My desire is to showcase the 97% - the document will be printed as an
> 11x17 poster, but I'm doing it in excel b/c we are creating multiple
> sheets for multiple posters.
>
> The problem is that I can't make the 97% any larger than 24 pt. font
> without the % sign going on a second line. I would like to make the
> font 48 pt or larger.
>
> Also, I can not put the 97% in a text box on top of the chart b/c it's
> linked to a data sheet and we'll be creating multiple sheets from this
> 'template'.
>
> Does anyone know how I can achieve a larger font within the chart? I'm
> working with XP Professional - 2003 Excel.
>
> Thank you!
> ~Jaci
>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)