Note: Make sure you have an Excel chart to run the code on the worksheet.

'the changes that you want to the chart legend. 'Place your LegendEntries macro code here to make With Worksheets('Sheet1').ChartObjects(1).Activate

To fix this, try to create a macro that shrinks/minimize the font size of the Excel chart legend text before the VBA macro, and then restore the font size of the chart legend. This error usually occurs when Microsoft Excel truncates the legend entries because of the more legend entries and less space availability. Sometimes, Excel throws the run-time error when you try to run VBA macro to change the legend entries in a Microsoft Excel chart. Try the below workarounds to fix Excel run-time error 1004: Create a Macro to Reduce Chart Legend Font Size It happens when the chart contains more legend entries than the available space, macro name conflicts, corrupt Excel files, or data-types mismatch in the VBA code. The run time error 1004 usually occurs when you run a VBA macro with the Legend Entries method to modify the legend entries in the MS Excel chart. In this blog, we have discussed the reasons and shared some solutions to resolve run-time error 1004. This error may occur due to the presence of more legend entries in the chart, file conflict, incorrect Macro name, and corrupt Excel files. Sometimes, when users try to run VBA or generate a Macro in Excel, the Run-time error 1004 may occur. VBA (Microsoft Visual Basic for Application) is an internal programming language in Microsoft Excel. MySQL Toolkit3-in-1 software toolkit to repair Corrupt Mysql, MariaDB & Analyze logs, and Interconvert Databases.Also supports recovery from RAIDs & Virtual Drives. Data Recovery ToolkitSoftware helps to recovers deleted data from Windows, Mac and Linux storage devices.MS SQL Toolkit5-in-1 software toolkit to repair corrupt SQL database, restore database from corrupt backup, reset database password, analyze SQL logs, & interconvert databases.It also repairs corrupt PDF files and recovers all objects. File Repair ToolkitPowerful file repair utility to fix corrupt Word, PowerPoint, and Excel documents created in Microsoft Office.Outlook ToolkitComprehensive software suite to repair PST files, merge PST files, eliminate duplicate emails, compact PST files, and recover lost or forgotten Outlook passwords.Exchange Toolkit5-in-1 software toolkit to recover Exchange database, convert EDB to PST, convert OST to PST, restore Exchange backup, and reset Windows Server password.

Excel qm add in office 365