Excel Graphing Tool

Create an Excel graphing tool that will streamline the process of editing a line chart. Line charts are based on tables of importance/performance ratings (words) that are converted to numbers using a look-up table. Chart edits will include the following: 1. Resize chart and keep y-axis labels (text boxes) aligned 2. Add/subtract x-axis categories (columns in the table) 3. Choose what lines to be plotted (x in plot column) 4. Add new lines to chart by adding new rows in table a) Match color in line title cell to line color b) Choose line type in line type column c) Use 3pt size lines everywhere 5. Adjust look-up tables a) Add new levels between the existing levels b) Choose abbreviations, words, scores and colors c) Add abbreviations to drop-down list in tables d) Don't need to add words to chart (use existing levels only) 6. Choose an x-axis categories to be highlighted on chart a) Use transparent box b) Match box to color selected in cell below the table