If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Font Size for Values in Charts
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
|
|||
|
|||
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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I change the font size of my "Folder List"? | FolderList Help | General Discussion | 1 | May 25th, 2005 05:01 PM |
In Word etc. should let me increase/decrease the size of ALL font. | Wishfull Thinker | General Discussion | 2 | January 3rd, 2005 12:43 AM |
cannot set font size to 10 in table | giovanni | Tables | 5 | November 11th, 2004 03:52 AM |
Font problem | Rich | Powerpoint | 12 | August 6th, 2004 04:48 AM |
Font size changes in Excel 2003 charts when re-opened | Lucie Harris | General Discussion | 0 | June 16th, 2004 05:52 AM |