With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
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 (ratings.xml - 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.
Sign in or Register to see more