Question about Access & Pie Charts

M

Moses

New Member
Joined
Aug 11, 2004
Messages
1
I have two tables linked together by a field and i am trying to dynamically create a Pie Chart based on the the second table results and apply same color code for each pie......ie

table one

portfolio
Personal
IRA
CRI

Table two

Portfolio FundFamily ProdName Value
Personal xxxxxxx y1 10
Personal xxxxxxx y2 15
IRA ttttttttttt y3 34
IRA xxxxxx y1 23
Personal tttttttttt y5 55

the talbles are linked by portfolio field. on the chart, i am selecting prodname and value ..... i need to color code based on the fundfamily.... same colors for each family in each pie chart.

Thank... Moses.
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
You must log in or register to reply here.

Similar threads

D
  • Question
Help me Identify where do these values come from
Replies
5
Views
830
Fluff
Fluff
A
  • Question
Help with existing code in Post - VBA to Create Org Chart
Replies
1
Views
2K
mrpotato562
M
W
  • Question
Converting a row of data into a pie chart
Replies
2
Views
2K
wootcat
W
K
  • Question
Dynamic Pie Graph - based on two dynamic fields
Replies
0
Views
821
KristiMiller
K
A
  • Question
How to create a Pie Chart showing percentage of Income Spent
Replies
0
Views
7K
alysonm
A

Forum statistics

Threads
1,221,792
Messages
6,161,997
Members
451,735
Latest member
Deasejm

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top