LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
COM COM is offline
external usenet poster
 
Posts: 40
Default Naming Chart

The only thing that I saw that was possible to name your chart, was.. After creating the chart, either programmatically with VBA, or by hand, that you went into the VBA editor and gave the chart object a name. Like the following

I created a chart on Sheet1
Then in the immediate window, I typed the following
Sheet1.ChartObject(1).Name = "ThisChart

Now, anytime I referenced Sheet1.ChartObject("ThisChart") I got the response(s) I expected when dealing with a Chart Object

Of course I would have to save the file for this renaming to remain, but that's up to you. :) I have no need for it

Does that make sense

If you created the chart using VBA code, you could or could have created the chart and given it a name at that time, and could continue to use that chart by name in the future.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Naming a chart object Jeff M Charts and Charting in Excel 6 September 23rd 08 06:00 AM
Chart Axis naming question SK Charts and Charting in Excel 1 May 12th 06 08:39 PM
Naming a Chart William Bartusek Excel Discussion (Misc queries) 2 March 16th 05 11:22 PM
Naming Chart Tom Ogilvy Excel Programming 0 July 15th 03 05:16 PM
Naming Chart pancho[_5_] Excel Programming 0 July 15th 03 04:47 PM


All times are GMT +1. The time now is 07:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"