Marketing Plan Pro: stop Appendix tables from overlapping Follow

Occasionally, when printing appendix tables, users find the numbers overlapping.

Numbers may overlap when there is too much data to display in the current space and format. There are a number of possible solutions:

First, remove yearly columns:

Your appendix tables are meant to convey the monthly details; annual totals are printed as part of the main body of the plan. If your appendix tables include columns for annual results, you can remove them to resolve the overlapping issue.

  1. On the Tools menu, point to Options and click Printing
  2. On the Include in Plan tab, find the drop-down menu below Appendix.
  3. Click the down arrow in this box and select any options other than "Print Months and Years"
  4. On the File menu, click Print Preview to see whether the problem has been resolved.

Change appendix font size:

If you wish to include the fiscal years, you will first want to set your appendix tables font to Arial Narrow.

  1. On the Tools menu, point to Options and click Printing
  2. Click the Font Settings tab
  3. Within this tab, click the Appendix tab
  4. Change the font to Arial Narrow
  5. Click OK
  6. On the File menu, click Print Preview to see whether the problem has been resolved.

Change printing margins:

  1. On the Tools menu, point to Options and click Printing
  2. Click the Margins tab
  3. Reduce the Left and/or Right margins to a smaller size. NOTE: This will affect all margins in your plan.
  4. On the File menu, click Print Preview to see whether the problem has been resolved.

Extraordinary situations

For most situations, the solutions above should be more than enough to resolve the problem. However, users dealing with a large-scale (or devalued) currency may wish to also consider the following options:

Rethink your scale:

If the numbers still overlap after trying all of the above options, your plan is probably dealing with very large numbers (6 or 7 digits). You may want to rethink the scale of your forecasts, especially if you are dealing with a currency in which small transactions require large numbers (70,000 pesos, or 3,000 CFA, etc.).

To change the scale, simply reduce all your plan's monetary numbers by the same factor - 100, to project in hundreds, 1,000 to project in thousands, etc. You will want to note the scale in your plan texts, and double-check your numbers to make sure you have changed them all by the same factor.

Export for more formatting options:

If the overlapping persists, you can export your plan as an RTF file. The process will create a second file for the appendix tables. Open this second file, format it, and print from the word processing environment. Another way to bring the information into an outside environment for printing would be to export the tables as an Excel file. Open the file in Excel, move to the desired spreadsheets, and print using the Fit to Page option in Excel.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments