Yearly Timeline Chart in Excel

[CCNY29]

Hi Everyone,


I work for a recruiting firm and my boss has asked me to put together a timeline for each of the searches we worked on in 2014, 2015 and 2016. I went week-by-week but the problem is that it doesn't fit onto one page when you print, or when you scroll.


My question is how can I create a timeline of all of our searches so that it will fit into one page and show the kickoff date of the search as well as the closing date?


Any help is greatly appreciated, thanks!

 

[CodeNinja]

Hi CCNY29,
Usually, you will need to provide more information than what you did here such as an example of the data etc. Without looking at this, you can scale your printing, although it may get very small if it is a large file.
Assuming you are in Excel 2007+, go to the page layout ribbon, highlight the range you wish to print and in the print area drop icon dropdown, select "Set Print Area". Next, under print menu, choose custom scaling and select fit sheet on one page.
The problem is, your data may get so small that you cannot read it. You may have to adjust the orientation, paper size (going to legal instead of letter), and may wish to tighten up on column widths or row heights to make everything be a more legible size.

Good luck,

CN.