VB Code to create or update Pie Chart colors created by a Pivot Table

A

Ali

Hi all

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

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Need VBA Code to create/update Pie Chart colors created by a Pivot Table 0
Dealing with a Pivot Table (when I don't want to) 0
Use different colors to show compoents of a pie slice 1
Pivot Chart update 1
How to create a pie chart with 793 numbers? Possible? 2
Using VBA to create charts 1
Pivot Table Chart? 4

Top