Excel 2003 chart legend colors

This project was awarded to excel4engineers for $35 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
Project Description

I have an example of a chart in an Excel 2003 spreadsheet where the colors for the legends and slices must be looked up from another column.

I want the attached example file ([url removed, login to view] - it will have to saved as .xls to allow for VBA functions) to have the slices ('Business Name') and the legend of the pie chart coloured by their 'Current Rating' values. The colors for the 'Rating' can be looked up in the background colors of the cells in the 'Rating' column. I also want the chart to recognise any patterns set on the 'Rating' cells.

Each slice of the pie chart should be equal in size. The color and pattern of each slice should be based on the 'Current Rating'. The colors and patterns are picked up from the 'Rating' column cell formats. The legend must also show the colors and patterns. The spreadsheet must be compatible with Excel 2003.

Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online