|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 18th, 2006, 08:14 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
Add Header Automatically to the Chart
How can I take the information written in the cell A1-sheet1 and then put it
automatically in the header of the chart that already created. Thanks in advance. Maperalia 
|
|
#2
March 18th, 2006, 01:40 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Add Header Automatically to the Chart
Use Chart Options to add a chart title such as Junk
On chart, select the dummy title and in the formula bar type =, now click on cell A1; press Enter Done best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "maperalia" wrote in message ... How can I take the information written in the cell A1-sheet1 and then put it automatically in the header of the chart that already created. Thanks in advance. Maperalia
|
|
#3
March 19th, 2006, 04:00 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Add Header Automatically to the Chart
Bernard;
Thanks for your quick respond. However, the way you advised me is the way I have been doing it. What exactly I am taking about is the headers and footer in the chart. You know under the page setup. I have noticed that you can put the file name, date, however, I can not costumize information that comes from the cells. Do you think you can help me with this matter. Thanks. Maperalia "Bernard Liengme" wrote: Use Chart Options to add a chart title such as Junk On chart, select the dummy title and in the formula bar type =, now click on cell A1; press Enter Done best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "maperalia" wrote in message ... How can I take the information written in the cell A1-sheet1 and then put it automatically in the header of the chart that already created. Thanks in advance. Maperalia
|
|
#4
March 19th, 2006, 02:14 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Add Header Automatically to the Chart
Confused by reference to CHART header when what is meant is printed page
header. See info here http://support.microsoft.com/?kbid=273028 best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "maperalia" wrote in message ... Bernard; Thanks for your quick respond. However, the way you advised me is the way I have been doing it. What exactly I am taking about is the headers and footer in the chart. You know under the page setup. I have noticed that you can put the file name, date, however, I can not costumize information that comes from the cells. Do you think you can help me with this matter. Thanks. Maperalia "Bernard Liengme" wrote: Use Chart Options to add a chart title such as Junk On chart, select the dummy title and in the formula bar type =, now click on cell A1; press Enter Done best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "maperalia" wrote in message ... How can I take the information written in the cell A1-sheet1 and then put it automatically in the header of the chart that already created. Thanks in advance. Maperalia
|
|
#5
March 19th, 2006, 04:32 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Add Header Automatically to the Chart
Bernard;
Thank you very much. This is exactly what I was looking for. I really appreciate your helping me with this matter. Best regards. Maperalia "Bernard Liengme" wrote: Confused by reference to CHART header when what is meant is printed page header. See info here http://support.microsoft.com/?kbid=273028 best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "maperalia" wrote in message ... Bernard; Thanks for your quick respond. However, the way you advised me is the way I have been doing it. What exactly I am taking about is the headers and footer in the chart. You know under the page setup. I have noticed that you can put the file name, date, however, I can not costumize information that comes from the cells. Do you think you can help me with this matter. Thanks. Maperalia "Bernard Liengme" wrote: Use Chart Options to add a chart title such as Junk On chart, select the dummy title and in the formula bar type =, now click on cell A1; press Enter Done best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "maperalia" wrote in message ... How can I take the information written in the cell A1-sheet1 and then put it automatically in the header of the chart that already created. Thanks in advance. Maperalia
|
|
#6
March 19th, 2006, 07:33 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Add Header Automatically to the Chart
You are most welcome
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "maperalia" wrote in message ... Bernard; Thank you very much. This is exactly what I was looking for. I really appreciate your helping me with this matter. Best regards. Maperalia "Bernard Liengme" wrote: Confused by reference to CHART header when what is meant is printed page header. See info here http://support.microsoft.com/?kbid=273028 best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "maperalia" wrote in message ... Bernard; Thanks for your quick respond. However, the way you advised me is the way I have been doing it. What exactly I am taking about is the headers and footer in the chart. You know under the page setup. I have noticed that you can put the file name, date, however, I can not costumize information that comes from the cells. Do you think you can help me with this matter. Thanks. Maperalia "Bernard Liengme" wrote: Use Chart Options to add a chart title such as Junk On chart, select the dummy title and in the formula bar type =, now click on cell A1; press Enter Done best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "maperalia" wrote in message ... How can I take the information written in the cell A1-sheet1 and then put it automatically in the header of the chart that already created. Thanks in advance. Maperalia
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I get text in a header (table) to automatically repeat | beaner | General Discussion | 1 | January 30th, 2006 11:00 PM |
| A Chart that Updates Automatically as Data Size Changes? | Notclevr | Charts and Charting | 4 | January 18th, 2006 04:19 PM |
| How to automatically add chapter title to header? | Paul Moore | New Users | 3 | June 9th, 2005 03:01 PM |
| Selecting Charts in a Macro | Herman Merman | Charts and Charting | 1 | August 18th, 2004 12:25 AM |
| Styles for chart | Debra Dalgleish | Charts and Charting | 1 | October 3rd, 2003 12:27 PM |
Linear Mode
