I am trying to place a pie graph of Market Values on a form in my database. This should be easy, but I just cannot get it to work.
The database is used to report and analyze clients' investment holdings. The data is supplied by flat file exports from commercial software. That basic data is simply each "tax lot" of each holding in each client account. The database sums that information, grouping on various characteristics of the holdings, so we are able to analyze and report on these holdings as needed.
Axys_Link_Summary_Table is the "master table" generated, daily, by a MakeTable query supported by numerous queries alluded to above. The database runs smoother by having these comprehensive queries generate this table for further use, rather than running compounded queries, frequently .
After using the Chart Wizard to place a simple pie chart on a form that displays summary information about an account, I have this in Row Source:
SELECT Axys_Link_Summary_Table.MV_Fx_Tot, Axys_Link_Summary_Table.MV_EQ_Tot, Axys_Link_Summary_Table.MV_Cash1 FROM Axys_Link_Summary_Table;
Column Count = 3
This is supposed to create a very basic chart showing "Stocks", "Bonds" and "Cash" as proportionate slices of their totals.
It doesn't. I get no slices, just a filled pie with a single radius line and a legend with the value of MV_Fx_Tot displayed (the total value of the "bonds" in the account).
To be clear, there is no need for Sum() since the table is data that has already been summed. I tried that, too.
I have tried all sorts of other approaches like creating a subform - get same result in that form, building a separate query from Axys_Link_Summary_Table - no luck.
What am I doing wrong??!!
Thanks in advance...