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.

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.

What I am trying to do is create a chart (as small as possible) and then
import that into a word document, and ideally make it larger or smaller. I'd
like the text to be quite small in the final chart (ie smaller than 8). I
can capture the chart as an image, and then make it a jpeg, but I lose
quality. What I was hoping to do was create a chart, import it into word,
and then click the corner of the imported chart to make it fit in the column
allocated....

"Pete_UK" wrote:

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.

Don't make it a jpeg. Select the chart in Excel, hold Shift while selecting
the Edit menu, and choose Copy Picture. Use the On Screen and Picture
options, then paste into Word. This is a metafile which contains all of the
individual shapes comprising the chart, so when you resize the pasted image,
it scales much more naturally. You will improve your results if you make the
chart in Excel as close as you can to the size it needs to be in Word.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Scott" wrote in message
...
What I am trying to do is create a chart (as small as possible) and then
import that into a word document, and ideally make it larger or smaller.
I'd
like the text to be quite small in the final chart (ie smaller than 8). I
can capture the chart as an image, and then make it a jpeg, but I lose
quality. What I was hoping to do was create a chart, import it into word,
and then click the corner of the imported chart to make it fit in the
column
allocated....

"Pete_UK" wrote:

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.