Need VBA Code to create/update Pie Chart colors created by a Pivot Table

A

Ali

Does anyone know the code I need to write to update the
colors in my Pie Charts? I have created a Pivot Table
from a query. The Pivot Table has about 20 different
categories (i.e. Parking, Vacant, Utilities,) in one
column and the land area of these categories in another
column. How would I code this so my Parking always comes
up blue (it reads a specific cell number or the name in
the field) and reads another cell value (land area) etc,
to create a pie chart.


P.S. I am a beginner.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top