Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Charts and graphs

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Charts and graphs

Resolved · Medium Priority · Version 2007

Reply Mon 23 Feb 2009, 16:04Delegate James said...

James has attended:
Access Intermediate course
Excel VBA Intro Intermediate course

Charts and graphs

How can I change the name of an active cell range in a graph without changing the data source?

For upcoming training course dates see: Pricing & availability

Reply Thu 5 Mar 2009, 13:07Trainer Amanda said...

RE: Charts and graphs

Hello James

Thank you for your question and welcome to the forum.

Can you please elaborate on your query further - it might help if you were able to send me an example spreadsheet relating to your question via email. If you would like to do this, please email your spreadsheet to amanda

thanks
Amanda

Reply Thu 14 May 2009, 10:16Trainer Rich said...

RE: Charts and graphs

Hi James,

How are you? Did you manage to figure this one out?
Did you manage to send a copy of your workbook to Amanda?

This question has now been left unattended for a while.

We like to keep down the large number of active forum posts we receive.

As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).

We look forward to hearing from you.

Thank you.
Regards, Rich

Wed 20 May 2009: Automatically marked as resolved.

Excel articles

· Differences In Excel 2003, 2007 And 2010
· Summing Up Scenarios With Excel
· MS Excel: Excel At Making The Most Of Your Christmas
· Understanding XML Within Excel
· How To Use Freeze Panes In Excel 2007

Please browse our web site to find out more about
excel-training-courses and other Microsoft training courses.

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips