paulmcdonnell
Ready to Help
- Local time
- Today, 04:43
- Joined
- Apr 11, 2001
- Messages
- 167
Hi guys,
I have two problems...
1)
I have a query report with 8 summation columns for assets is areas ie
deposit____equity_____ etc...
343_______231______ etc...
I want to create a pie chart showing what proportion of the whole each of these columns makes up.
I can create a chart when you have one column and several rows, how do I create one with the columns being the source if the chart data when I only have one row..?
2) I want my legend to display shortened titles. At the moment it uses column names from my query i.e. "SumOfQuery_funds breakdown totals - bonds" I want the legend just to display "bonds". I cant find how to the these in the chart design, do I have to change the names of the columns in my query... If so how do you use the expresion to create this new name (Tried and can only get the chart to work with the query column names..
CAN YOU HELP???
Cheers
paul
[This message has been edited by paulmcdonnell (edited 01-13-2002).]
I have two problems...
1)
I have a query report with 8 summation columns for assets is areas ie
deposit____equity_____ etc...
343_______231______ etc...
I want to create a pie chart showing what proportion of the whole each of these columns makes up.
I can create a chart when you have one column and several rows, how do I create one with the columns being the source if the chart data when I only have one row..?
2) I want my legend to display shortened titles. At the moment it uses column names from my query i.e. "SumOfQuery_funds breakdown totals - bonds" I want the legend just to display "bonds". I cant find how to the these in the chart design, do I have to change the names of the columns in my query... If so how do you use the expresion to create this new name (Tried and can only get the chart to work with the query column names..
CAN YOU HELP???
Cheers
paul
[This message has been edited by paulmcdonnell (edited 01-13-2002).]
