Excel 2003 chart legend colors

Closed

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.

Skills: Excel, Visual Basic for Apps

See more: excel 2003 chart, excel legend, legend color excel vba, vba pie pattern colors, vba chart legend, excel 2003 pie chart, excel 2003 chart colors, chart legend colors, formats in excel, excel 2013 vba, xml excel, legends, legend, excel visual basic, colors, excelchart, 2013 visual basic applications excel, excel rating, xls visual basic, excel slice, 2013 excel visual basic, chart example, excel 2013 visual, xml file excel, excel vba spreadsheet

Project ID: #4230669

Awarded to:

excel4engineers

Please refer to my private message to get my exclusive offer.

$35 USD in 1 day
(15 Reviews)
3.4

12 freelancers are bidding on average $89 for this job

ZeusMan

Looking forward to working with you...

$95 USD in 1 day
(49 Reviews)
5.6
mrbrave

Expert in Excel/VBA here...Lets start.

$80 USD in 1 day
(61 Reviews)
5.3
FIBIN

Hi, I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% More

$70 USD in 1 day
(39 Reviews)
5.2
nayabsiddiqi

hello can do the required thing "Error-Free" in next 2 days.

$175 USD in 3 days
(6 Reviews)
3.7
Gooroo

*SEEK NO MORE Sir!* I will do this quickly and accurately. I SENT you a SAMPLE in PM. Thanks!

$68 USD in 0 days
(9 Reviews)
3.7
muzammil21

we do not offer package we offer Only guaranteed results..100% quality work within time limit and ...Read more in PMB

$100 USD in 2 days
(2 Reviews)
2.1
ietim

New freelancer, experienced excel worker.

$100 USD in 2 days
(1 Review)
1.7
amolpandey

I have a good background in VBA related task as required, and hope to solve this task in the best of your expectations. My work profile can be checked for similar task at: www.amolpandey.com Thanks, look forwar More

$90 USD in 2 days
(0 Reviews)
0.0
jsuarezg

Hello, I'm expert in Excel and VBA. I can do this for you. I guarantee that the work is like you want.

$50 USD in 1 day
(0 Reviews)
0.0
MrCosAdy

I can do it!

$100 USD in 1 day
(0 Reviews)
0.0
uttora

Hi, I am excellent in Excel vba. I mainly build advanced statistical models in Excel VBA. These models are very visual (like dash board). You can rely on me.

$100 USD in 3 days
(0 Reviews)
0.0