Error when assigning a macro to an Excel Chart Sheet

BobBridges · #1 09-13-2023, 11:36 AM

My VBE agrees that OnAction is not a property supported by a Chart object. But when I try to record my own macro to see about that part, I realize I don't know how to assign a macro to a chart. I right-clicked on your chart area, but I don't see an option in the list about assigning a macro to it. What method did you use when recording your macro?

soroush.kalantari · #2 09-15-2023, 02:11 PM

Quote:

Originally Posted by BobBridges

My VBE agrees that OnAction is not a property supported by a Chart object. But when I try to record my own macro to see about that part, I realize I don't know how to assign a macro to a chart. I right-clicked on your chart area, but I don't see an option in the list about assigning a macro to it. What method did you use when recording your macro?

Thank you for your reply. As the attached picture shows, I select the select the chart and then right clicked on it.

BobBridges · #3 09-15-2023, 07:50 PM

Interesting; that option doesn't appear when I right-click on the area. We must be using different flavors of Excel. Guess I can't help you; sorry.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel data sheet size when opening powerpoint chart	Sissy	PowerPoint	0	08-15-2019 04:35 AM
Excel Macro: Multiple Search and Post in Excel Sheet	andxie	Excel Programming	10	05-31-2018 05:21 PM
Error in exporting Google Sheet to Excel	cmcmeekin	Excel	2	08-03-2016 11:32 AM
How To Open an Macro From 2003 Excel in 2013 Excel Spread Sheet?	ADubin	Excel Programming	3	02-08-2015 04:57 AM
Excel 2010 Chart SetSourceData 1004 error	pocerus	Excel Programming	4	10-26-2014 08:10 AM