I have so many charts, I don't what sheets have which charts or where they are on the sheet. Scrolling around is driving me crazy!
Solution - Use the Chart Selecter tool
The Chart Selecter tool allows you see all charts in the active workbook and select them without having to scroll to where they are.
I have to reset the ranges or labels in a lot of charts. Not only is it time consuming, it's also prone to user error since it's such a boring and repetitive task.
Solution - Use the Series Find and Replace tool
It helps you find and replace in series values in the active chart, all charts on the active sheet, or the entire workbook.
Problem 3I have so many charts, with so many series. Sometimes the chart type and series chart type are different, some have a secondary axis, etc, etc. I wish there was a way I could see the details of all the charts I'm working with.
Solution - Use the Workbook Chart Report
It tells you details of all charts in the workbook. Information includes the Sheet Name, Chart Name, Chart Type, Series Name, Series Formula (range references and series number), Series Axis Type and Series Chart Type.
All of the tools above sound good. But my workbook is so slow and it takes so long for my charts to render. Is there a faster way to see them?
Solution - Export the charts as images
The Export Charts as Pictures tool allows you to export whatever charts you want from the active workbook as GIF, JPG or PNG files. Using Preview on Windows Explorer right-click menu, you can browse through the charts that you exported using the navigation arrow buttons at the bottom. This is also a great way to keep a backup of your charts so you know what they looked like before you edited them.
You can download AET Chart Tools here!