Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Property Confusion
I have 12 charts objects, 4 per sheet, three sheets.
I need to assign sequential numbers to each grouping of 4. When I hold CTRL+Shift then click on the chart and I try to change the chart name Im running into problems. One grouping is named as follows; Chart 11, Chart 2, Chart 3, Chart 77. When I change Chart 77 to Chart 4, Chart 11 activates. How do I change these properties to what I want? Sincerely, Arturo |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Property Confusion
Hi,
Normally when you enter an exiting name into the name box and press enter it will take you to that item. Sounds like Chart 4 already exists or Excel is just confused. Perhaps try renaming Chart 11 temporarily and see if the problem persists. Cheers Andy Arturo wrote: I have 12 charts objects, 4 per sheet, three sheets. I need to assign sequential numbers to each grouping of 4. When I hold CTRL+Shift then click on the chart and I try to change the chart name Im running into problems. One grouping is named as follows; Chart 11, Chart 2, Chart 3, Chart 77. When I change Chart 77 to Chart 4, Chart 11 activates. How do I change these properties to what I want? Sincerely, Arturo -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Property Confusion
Hey Andy,
I ended up renaming everything Chrt 1, Chrt 2 etc... Though there are no duplicate chart names on the sheet Chart 1 ect would still not take. Thanks, Arturo "Andy Pope" wrote: Hi, Normally when you enter an exiting name into the name box and press enter it will take you to that item. Sounds like Chart 4 already exists or Excel is just confused. Perhaps try renaming Chart 11 temporarily and see if the problem persists. Cheers Andy Arturo wrote: I have 12 charts objects, 4 per sheet, three sheets. I need to assign sequential numbers to each grouping of 4. When I hold CTRL+Shift then click on the chart and I try to change the chart name Im running into problems. One grouping is named as follows; Chart 11, Chart 2, Chart 3, Chart 77. When I change Chart 77 to Chart 4, Chart 11 activates. How do I change these properties to what I want? Sincerely, Arturo -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Property Confusion
Looks like it remembers previous names.
I did a simple test create a chart, which will be called Chart 1. Rename to Chart 4. Create another chart, which will be called Chart 2. Try naming this Chart 1 and the chartobject Chart 4 is selected. Saving and closing workbook or excel did not clear the name. weird. Cheers Andy Arturo wrote: Hey Andy, I ended up renaming everything Chrt 1, Chrt 2 etc... Though there are no duplicate chart names on the sheet Chart 1 ect would still not take. Thanks, Arturo "Andy Pope" wrote: Hi, Normally when you enter an exiting name into the name box and press enter it will take you to that item. Sounds like Chart 4 already exists or Excel is just confused. Perhaps try renaming Chart 11 temporarily and see if the problem persists. Cheers Andy Arturo wrote: I have 12 charts objects, 4 per sheet, three sheets. I need to assign sequential numbers to each grouping of 4. When I hold CTRL+Shift then click on the chart and I try to change the chart name Im running into problems. One grouping is named as follows; Chart 11, Chart 2, Chart 3, Chart 77. When I change Chart 77 to Chart 4, Chart 11 activates. How do I change these properties to what I want? Sincerely, Arturo -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Property Confusion
I've noticed this funny behavior. For this reason, I always use something
other than "Chart X" as custom chart object names. The more descriptive, the better. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Andy Pope" wrote in message ... Looks like it remembers previous names. I did a simple test create a chart, which will be called Chart 1. Rename to Chart 4. Create another chart, which will be called Chart 2. Try naming this Chart 1 and the chartobject Chart 4 is selected. Saving and closing workbook or excel did not clear the name. weird. Cheers Andy Arturo wrote: Hey Andy, I ended up renaming everything Chrt 1, Chrt 2 etc... Though there are no duplicate chart names on the sheet Chart 1 ect would still not take. Thanks, Arturo "Andy Pope" wrote: Hi, Normally when you enter an exiting name into the name box and press enter it will take you to that item. Sounds like Chart 4 already exists or Excel is just confused. Perhaps try renaming Chart 11 temporarily and see if the problem persists. Cheers Andy Arturo wrote: I have 12 charts objects, 4 per sheet, three sheets. I need to assign sequential numbers to each grouping of 4. When I hold CTRL+Shift then click on the chart and I try to change the chart name I'm running into problems. One grouping is named as follows; Chart 11, Chart 2, Chart 3, Chart 77. When I change Chart 77 to Chart 4, Chart 11 activates. How do I change these properties to what I want? Sincerely, Arturo -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |