HELP!! URGENT!! How to CHANGE TITLES IN CHARTS
I have an Excel XP application that has lots of charts. The name of
the client is entered in a separate spreadsheet and linked to the other spreadsheets. That works just fine. However, I would like to be able to change the CHART TITLES automatically so that the name of the client changes automatically and inclues the subject of the chart along with the date of the chart. Example. Shady Palms Salon - Comparative Cashflows - Years 12-31-03 through 12-31-08 I need precise instructions on how to do this including whether I should use the Macro editor or VBA editor and where I should enter the code. Please respond via email AT: I will show you how to automatically change the date headings in columns for either a calender year or fiscal year. Works great for working with projections like budgets and cashflow projections. |
HELP!! URGENT!! How to CHANGE TITLES IN CHARTS
Hi,
- Download my flexfind.zip from www.bmsltd.co.uk/mvp - Install it - Open your workbook - Press control-shift-F - type the name of the client to look for - Check the "Objects" box - increase the height of the form using the little button near its top - type the new name into the replace box - select all entries you need replaced - click replace. Regards, Jan Karel Pieterse Excel TA/MVP -----Original Message----- I have an Excel XP application that has lots of charts. The name of the client is entered in a separate spreadsheet and linked to the other spreadsheets. That works just fine. However, I would like to be able to change the CHART TITLES automatically so that the name of the client changes automatically and inclues the subject of the chart along with the date of the chart. Example. Shady Palms Salon - Comparative Cashflows - Years 12-31- 03 through 12-31-08 I need precise instructions on how to do this including whether I should use the Macro editor or VBA editor and where I should enter the code. Please respond via email AT: I will show you how to automatically change the date headings in columns for either a calender year or fiscal year. Works great for working with projections like budgets and cashflow projections. . |
All times are GMT +1. The time now is 04:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com