Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vux
Starting Member
45 Posts |
 Posted - 2004-08-08 : 23:32:36
|
| Hello,I simply wnt to generate a pie chart where the values for the colums A,B,C,D are represented:A/ B /C /D1_ 2_ 3_ 4The wizzard is just asking me for one value for data and one for series, I dont know how to use the wizzard - can someone here help me generating this graph?Another thing not working is to show a value on the graph sheet that the user has to enter when running the report.In the normal report I am able to show the value, simply by adding a field with the same name as the field in the query (Year), here is the query source:WHERE [Overview].[TravelYear]=[Year]Do you know how to show a value on the graph sheet which the user has to enter when running the graph report?Thanks for your help! |
|
|
Sam Freeman
Starting Member
8 Posts |
Posted - 2004-08-11 : 14:18:31
|
| Hi VUX:Sorry to say, you cannot create a Pie Chart in Access with more than one series, and you have 4. You CAN create a column chart with your scenario of 4 columns, AND you can add a fifth column in the query that will promt the user for a value.Assuming a table named 'Table1' with 4 columns A, B, C & D, here is the basic query:SELECT Null AS Expr1, Table1.A, Table1.B, Table1.C, Table1.D, [Please enter a value for column E:] AS EFROM Table1; Just copy this and paste it into your query SQL design view.Once the table and query are created, create a report based on the query using the Chart Wizard. Add all of the columns. If you immediately view the chart, you will get an error message. Drag column E off of the chart. Then add columns B thru E just under where Column A is. Preview the chart, and it should look OK. Save, repeat and rinse, uh, no, just save. :-B HTH |
 |
|
|
|
|
|
|
|
simple pie chart