Your current attachment is precisely what I was trying to do. Thanks for the link but the timeline we're using is just the flavor I'm looking for.ġ.
If this turns into too much of a PITA, I can go back to my version and create individual worksheets for whatever number of activities easily fit on one page then print out whatever number of worksheets are then required. Where can I change that view setting? I've right clicked the date image rectangle and tried several of the click options but cannot find an obvious method to change the date appearance? Additionally, the default style for my dates is angled, allowing them to fit. On my version timeline, the default (and the way I would like to see it) displays all dates vs. However, if I do the same in my timeline version (view, page break preview, right click cell just under chart where I want the break, click insert page break) no page break line appears?Ĥ. I did as you said and added another page break.
I can't delete the column, it'll mess with the chart?ģ. If I clear the contents of the column the space still appears on the chart. Your sheet has an 'assigned to' data field that is not needed. Obviously, I chose the wrong method to eliminate background color?Ģ. This resulted in the background color going none but also wiped out all the chart text. I clicked on the upper left corner (all), then ribbon\font\fill\none. The entire sheet now has a black background color vs. There's surely tons of instances where folks have huge data sets that require multiple pages of chart representation?īig help but more questions, largely my lack of chart knowledge. Is it therefore not possible for a chart image to involve more than 1 page wide? That just doesn't seem right. I went back to page break and still 1 page. I then clicked on the chart image of the timeline, grabbed the lower right corner and expanded the chart to where the text was no longer scrunched and was clearly readable. No change in the page break preview-still 1 page. I need to release that restriction but have no clue where to look? There must? be 'something' in this sheet that's restricting the timeline to 1 page. I've always had to involve page break preview and page setup to control the 'normal' expansion of sheets both across and down. I've never run into a situation like this. When I scrolled up to the timeline image after a while, it was 'scrunched' to fit 1 page wide. There's a table at the bottom and a corresponding (reactive) timeline with milestones above that is populated by inserted table date, title, width information.Īll was proceeding swimmingly until I added a goodly number of table data points (lines). I downloaded what I believe to be a MS Excel project timeline template (.xlsx).
0 kommentar(er)
