Description:
This add-in provides several chart-related utilities:
- Data Labels - Lets you specify a worksheet range for the data labels for a chart series. Amazingly, Excel does not provide this capability!
- Chart Size - Lets you specify an exact size for a chart, or lets you make all charts the same size.
- Export - Lets you save charts as GIF, JPG, TIF, or PNG file.
- Picture - Converts a chart to a picture (color or grayscale)
- Text Size - Freezes the size of all text items in a chart. When the chart is resized, the text elements will not change size.
- Chart Report - Generates a summary report for all charts, or a detailed report for a single chart.
Requirements:
This add-in requires Excel 97 or later.
Cost:
This add-in is free (no strings attached). Those who purchased the VBA source code for PUP v5 will also be able to access the source code for the J-Walk Chart Tools add-in.
Installation:
- Download the J-Walk Chart Tools add-in (347K). This is a self-extracting EXE file.
- Extract the XLA add-in file by double-clicking the J-WalkChartTools.exe file (the file you downloaded in Step #1).
- Start Excel and select the Tools - Add-Ins command.
- In the Add-Ins dialog box, click the Browse button and locate chart tools.xla (the file you extracted in Step #2).
- Click OK
- The Chart menu will display a new menu item: J-Walk Chart Tools. This menu item will also appear when you right-click many of the elements within a chart.
Problems?
This add-in has not been tested thoroughly with all versions of Excel. Please report any problems to support@j-walk.com