Font Size for Values in Charts

[Jaci]

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

 

[Jon Peltier]

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/
_______