Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Page header and footer for charts from my template
I plot a lot of Y vs X data as scatter plots. Usually, I want the graphs as
separate sheets. For these sheets, I want a standardized header and footer. Presently, I do this manually by 1. Select the chart location as New sheet, with a name 2. In the new sheet, click the Print Preview button 3. Click Setup... 4. enter Custom Header and Custom Footer data. I always enter the same data in step 4 above. It should be ideal for a template. Is there a way to use a template for this? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Page header and footer for charts from my template
Next time you add charts, assuming you add them to end of your workbook,
click the last sheet that already has a header/footer, shift click on the last new sheet to group them. Choose File, Page Setup, on the header/footer tab, you should see the data from the first (already done) worksheet in your selection. Click ok and now it has been applied to all of the selected sheets. Bottom line, if you do page setup of headers and footers (or anything else for that matter) in page setup from the menu bar instead of from print preview, it will apply to all selected sheets as long as they are all the same kind of sheet. Select all chart sheets, or all regular worksheets. Select first sheet and shift click last sheet will group those two sheets and all between. ctrl click will allow you to add or remove individual sheets. As soon as you have finished, be sure to ungroup by right clicking a selected sheet tab and choose ungroup sheets, or click a sheet outside of the group. (editing done on a sheet in a group applies to all sheets) "Verktum" wrote: I plot a lot of Y vs X data as scatter plots. Usually, I want the graphs as separate sheets. For these sheets, I want a standardized header and footer. Presently, I do this manually by 1. Select the chart location as New sheet, with a name 2. In the new sheet, click the Print Preview button 3. Click Setup... 4. enter Custom Header and Custom Footer data. I always enter the same data in step 4 above. It should be ideal for a template. Is there a way to use a template for this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Header & Footer make template for multiple users | Excel Discussion (Misc queries) | |||
header/footer from page | Excel Worksheet Functions | |||
View Header/Footer in Charts | Charts and Charting in Excel | |||
header/footer "page 1 of 'x' pages" | Excel Discussion (Misc queries) | |||
Template for printing-orientation, header-footer setup | Excel Worksheet Functions |