View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Chart with small text

I presume you are using the Excel sheet as a piece of graph paper,
rather than generating a chart? You can adjust your printout to print
in Landscape rather than Portrait mode, and you can also select Print
to Fit using File | Page Setup | Page (tab) and ticking the appropriate
boxes. You might also think about rotating your numbers to be oriented
vertically.

Hope this helps.

Pete

Scott wrote:

I'm trying to make a small chart that would have days of the month (35 in
total)along the bottom and a square above each number that could be colored
to indicate certain days. I did it in excel using a column width of 2, and
an arial font of 8. However, when I print it, it extends over 1 page. And
if I copy it and paste it into a word document it doesn't fit on the page,
and I can'r shrink it. Is there a way to have really small boxes and text
(ideally I'd like 35 columns, with a number in each, fitting on half of one
page). I know it can done as I see small print and columns in other places.
Any suggestions. Thanks.