Truncated Y-Axis Labels on Excel 2003 Charts?
143764
unfortunately there does not seem to be an official fix or patch from Microsoft. The knowledge base article appears to be Microsoft’s only information on the issue.\n\n“The problem is due to a combination of font size, zoom factor, screen resolution,  and a few other monitor related parameters ("pixel aspect ratio"). It's frustrating because it isn't really predictable, and it isn't  easy to get rid of.”\n\n“The problem seems to go away in print preview and in printed copy.”\n\nTherefore there doesn’t seem to be a straightforward fix.
133790
use chart wizard in Excel ... 2nd button to the left of zoom% box on toolbar.
176894
Find a blank space on the bar above.\n\nRIGHT click on it.\n\nMake sure formatting and standard are checked.\n\nThat will bring it back for you.  :)
908613
1. Start with a new workbook and enter your task data as in Sheet1. Column A contains the task descriptions, column B contains the beginning date for each task, and column C contains the number of days to complete the task. Column D contains formulas thhat determine the ending day for each task. For example, the formula in cell D2 is =B2-C2-1. Column D isn’t really necessary (and is not used in the chart), but including it will tell you end dates easily.\n\n2. Create a stacked horizontal chart from the data in A2:C13. The Chart Wizard will probably guess these series incorrectly, so you’ll need to set the category axis labels and data series manually. The category (x) axis labels should be range A2:A13, the Series 1 data should be B2:B13, and Series 2 data should be C2:C13. \n\n3. Remove the chart’s legend and adjust the height of the chart so that all of the category axis labels are visible (or, change the font to a smaller size). \n\n4. Access the Format Axis dialog box for the horizontal (value) axis. Set the Minimum and Maximum values to correspond to the earliest and latest dates in your project. Note that you can\nenter actual dates into this dialog box. To display the dates at weekly intervals, set the Minimum to a Monday, the Maximum to a Sunday, and the Major Unit to 7. \n\n5. Select the data series that corresponds to the data in Column B and access the Format Data Series dialog box. Set Borders to None and Area to None. This essentially makes the first data\nseries invisible – and makes the chart resemble a Gantt chart.\n\n6. Apply other formatting as desired. For example, you may want to add gridlines and a title. You’ll be able to adjust your project schedule and the chart will update automatically. However, if you use dates outside of the original date range, you’ll need to change the scaling for the horizontal (value) axis.
1003541
Try using the > LPTx command, assuming your printers are set up correctly for DOS printing. See http://www.computerhope.com/issues/ch000199.htm .
150023
if the cell is specifically formatted to be "text", then that can happen.  Go to "Format", "Cell", then change the format to "General"\n\nI just went to Excel and check it, and "text" format caused the problem and putting it to "general" and retyping the equation fixed the problem.
908631
The Data | List... command is new to Excel 2003.
618625
It's not clear whether you want to do this manually or via a 'macro' (i.e., in Visual Basic), but anyway, here's the Visual Basic.\n\nTurn off gridlines and column and row headings:\n\nActiveSheet .PageSetup .PrintGridlines = False\nActiveSheet .PageSetup .PrintHeadings = False\n\nFormat headings using some text formatting:\n\nWith ActiveSheet .Range("A1:A5")\n  .RowHeight = 20\n  .Font.Bold = True\n  .Font.Size = 12\nEnd With\n\nSet borders around an area (e.g., summary):\n\nWith Worksheets("Sheet1") .Range("D3:F7") .Borders\n  .LineStyle = xlContinuous\n  .Weight = xlDouble\nEnd With
1173904
(1)either the font you are using makes the problem. just try to change that font and then check. (2) u just increase the  column width. (3)it can also happen if u r  using some formulal in that column. if the number is an infinite value , then it may show ##
279670
Using Excel is your best bet. You can cut and paste as suggested or embed the Excel tables into Word and be able to format them. If you do not have access to Excel, about all you can do is import the csv into mail merge. Here is a link with some explanation on that process.\nhttp://www.gmayor.com/convert_labels_into_mail_merge.htm
452391
When you create a chart, do not specify the data range with a range of cells, use a dynamic range. The range will expand automatically when data is loaded, at the top or bottom. See the Source link for several examples.
914305
Mimic a watermark in Excel   \nWatermark functionality is not available in Excel. If you want to display a graphic on every printed page (for example, to indicate that the information is confidential), you can insert the graphic in a header or footer. This way, the graphic appears behind the text, starting at the top or bottom of every page. You can also resize or scale it to fill the page.\n\n-On the View menu, click Header and Footer. \n-In the Page Setup dialog box, click Custom Header or Custom Footer. \n-Click in the Left section, Center section, or Right section box. \n-In the row of buttons in the Header or Footer dialog box, click -Insert Picture  and then find the graphic you want to insert. \n-Double-click the graphic to insert it in the header or footer section box. \n-To resize or scale the graphic, click Format Picture  in the row of buttons in the Header or Footer dialog box and then, in the Format Picture dialog box, select the options you want on the Size tab.
857302
If this is an excel file, go to the page set-up it has an adjust to: %, if this is say at 45% then the text/numbers will come out very small. Adjust it to a higher number to get it the text/numbers to come out larger.
554626
Do you have word? If you do, then you can go to tools - envelopes and labels and choose the type of label you have. Then you need to click on "new document" this will put the lines where they are supposed to be. \n\nIf you don't have word, all I can say is to set up the cells in excel to be where the labels fall by trying it on blank pieces of paper. \n\nIt would be easier in Word though...
488375
Hi Casp911\n\nI have not seen the formula spaces anywhere.... the formula is REPT.. .so, taking the example of Dragon Dave\n\nH6&Rept(30-LEN(H6))\nthe question here is if you are exporting the info from Excel or importing directly from the other program... if the other program is a microsoft one, you can solve your problem using a simple macro\n\nlet me know if i can be of further help
393718
It sounds like you are using Excel as a form template of sorts.  I gather that your goal here is to prevent people from entering endless text answers, and instead keep their replies brief.\n\nWhat you may need to do is limit the text answers to a certain number of characters, rather than words.  If you select the cell that will hold the text answer, and go on the menu to Data > Validation, then under the Settings tab, select text length.\n\nSet this to some value like 1000 characters, and you will get the result you seek.  Also you can adjust the error message that the user will see in here.\n\nIn old versions of Excel there was a frequent limit of 255 characters in a cell.  As long as you have a recent version (such as Excel 2003) you will be able to store and save worksheets with more than 255 characters.  However if you attempt to copy the entire worksheet you will receive a truncation warning.  To get around this, just copy and paste the individual cells, and the Excel will let you get away with it.
874841
U can go for truncate command.\n\ntruncate table <table_name>\nLoop thru all the tables.