Excel 2003 chart legend colors

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.

Taidot: Excel, Visual Basic for Apps

Näytä lisää: 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

Tietoa työnantajasta:
( 6 arvostelua ) Glasgow, United Kingdom

Projektin tunnus: #4230669

Myönnetty käyttäjälle:


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

$35 USD 1 päivässä
(15 Arvostelua)

12 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Looking forward to working with you...

$95 USD 1 päivässä
(49 arvostelua)

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

$80 USD 1 päivässä
(61 arvostelua)

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% Lisää

$70 USD 1 päivässä
(39 arvostelua)

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

$175 USD 3 päivässä
(6 arvostelua)

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

$68 USD 0 päivässä
(9 arvostelua)

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

$100 USD 2 päivässä
(2 arvostelua)

New freelancer, experienced excel worker.

$100 USD 2 päivässä
(1 arvostelu)

I can do it!

$100 USD 1 päivässä
(0 arvostelua)

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 3 päivässä
(0 arvostelua)

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 1 päivässä
(0 arvostelua)

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: [url removed, login to view] Thanks, look forwar Lisää

$90 USD 2 päivässä
(0 arvostelua)