Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 72
Default Setup Chart name

I created a bunch of charts of a sheet and I noticed that you can setup a
name per chart. I tried to do it from the chart properties menu but was not
able to find it. Where can I set the name of a chart so I can refer to it in
my VBA as "piechart" or "trendchart".

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default Setup Chart name

Select the chart and enter a name in the "name" textbox.

Tim

"matelot" wrote in message ...
I created a bunch of charts of a sheet and I noticed that you can setup a
name per chart. I tried to do it from the chart properties menu but was not
able to find it. Where can I set the name of a chart so I can refer to it in
my VBA as "piechart" or "trendchart".

Thanks



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,124
Default Setup Chart name

One way
Hold down the shift keyselect the chart edgeyou will see chart1 or another
number in the NAME box to the left of the formula box type in the desired
name.

--
Don Guillett
SalesAid Software

"matelot" wrote in message
...
I created a bunch of charts of a sheet and I noticed that you can setup a
name per chart. I tried to do it from the chart properties menu but was
not
able to find it. Where can I set the name of a chart so I can refer to it
in
my VBA as "piechart" or "trendchart".

Thanks



Reply
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
How to setup Darlene Charts and Charting in Excel 0 October 9th 08 07:43 PM
How to setup an age profile spreadsheet and chart jorel Charts and Charting in Excel 1 June 8th 08 08:17 PM
Setup cmorga20 Excel Discussion (Misc queries) 1 July 13th 06 08:15 PM
how do I setup a pie chart that does not plot zero values ? Dimmy Charts and Charting in Excel 1 June 24th 06 12:44 PM
Can I setup mixed bar chart where last column is stacked? Wobbly Steve Charts and Charting in Excel 1 October 3rd 05 04:35 PM


All times are GMT +1. The time now is 03:22 AM.

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

About Us

"It's about Microsoft Excel"