Pie Charts

B

Bulldog1998

I have an asset allocation query that populates a pie chart graph.
Sometimes, the pie chart will have 2 asset classes, other times there could
be 3 or 4 depending on the portfolio. Can I assign a specific color to a
certain group or does Access generate the color based on the number of asset
classes.
For Example, I want Stocks to be BLUE, Bonds to be RED, and Cash to be YELLOW.
If a portfolio does not have Bonds, I still want Stocks to be BLUE and Cash
to be YELLOW. I do not want Cash to be RED. Can I accomplish this somehow?
 
A

Alla

Hi
I was just wondering if you ever figure out how to do it? I have a similar
problem. Please let me know. My email (e-mail address removed)
I appreciate your help. Thanks, Alla
 

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

Pie chart segment colors using VBA? 1
Specific colors in a pie chart 3
excel charts 0
Creating a dynamic asset allocation chart 1
Defined colors in pie charts 0
Custom Chart Options 0
Bar Chart with Data Elements 1
Hlookup problem in knowing what range to use 4

Top