Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Template for header in charts
I like to have date and filename on all printouts. Therefor I've made
an Excel template file, where the Header/Footer fields are already filled in with such things. When I add a new sheet to an Excel file, I use my template file. However, when the location of a chart is changed from "in the table" to its own tab, the headers and footers are blank. I want my standard header and footer. Is there a way to either: - choose a template file when the chart is created or located to its own tab? - or change my template, so that header information for new charts have the contents I want? Best regards, Helge |
#2
|
|||
|
|||
You could create a custom chart type, including the header/footer
settings that you want, and set it as the default. Jon Peltier has instructions on his web site: http://peltiertech.com/Excel/ChartsH...stomTypes.html Helge Stenstroem wrote: I like to have date and filename on all printouts. Therefor I've made an Excel template file, where the Header/Footer fields are already filled in with such things. When I add a new sheet to an Excel file, I use my template file. However, when the location of a chart is changed from "in the table" to its own tab, the headers and footers are blank. I want my standard header and footer. Is there a way to either: - choose a template file when the chart is created or located to its own tab? - or change my template, so that header information for new charts have the contents I want? Best regards, Helge -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linkingof charts in worksheets to cells | Excel Discussion (Misc queries) | |||
Can't create dynamic charts | Charts and Charting in Excel | |||
is there a template for daily cleaning charts for restaurant mana. | Charts and Charting in Excel | |||
i need help automating, or at least simplifying, my charts | Charts and Charting in Excel | |||
Template Wizard with Data Tracking | Excel Discussion (Misc queries) |