| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Delete Chart
How do I delete a chart that will not allow me to click on it?
|
|
#2
|
|||
|
|||
|
If the sheet has been protected, you need to unprotect it first (Tools menu).
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ agac8103 wrote: How do I delete a chart that will not allow me to click on it? |
|
#3
|
|||
|
|||
|
It's not protected.
"Jon Peltier" wrote: If the sheet has been protected, you need to unprotect it first (Tools menu). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ agac8103 wrote: How do I delete a chart that will not allow me to click on it? |
|
#4
|
|||
|
|||
|
Is it an embedded chart object?
Where did you get it from? Select the chart, press ALT+F11 to open the VB Editor. Press CTRL+G to open the Immediate Window. Enter this line and press Enter: ?activechart.ProtectSelection it will return False if it isn't protected. Enter this line and press Enter: ?activesheet.protectcontents it will return False if it isn't protected. If this doesn't clarify things, post back. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ agac8103 wrote: It's not protected. "Jon Peltier" wrote: If the sheet has been protected, you need to unprotect it first (Tools menu). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ agac8103 wrote: How do I delete a chart that will not allow me to click on it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
| Changing chart orientation | Charts and Charting in Excel | |||
| Creating an x,y coordinate chart | Charts and Charting in Excel | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
| Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel | |||
Hybrid Mode
