Software

Ask something
Discussion Locked

Graphing in Access

0 helpful
3 replies

by dakota99

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In all the reference material I have found on the net, Microsoft Graph is mentioned as the means to add graphs to Access forms or reports. Yet I have not found anything about Microsoft Graph being a seperate software package. Can you purchase Microsoft Graph or is this a builtin segment of Microsoft applications?

Second, When using the chart wizard in Access 2000, you can only add up to 6 fields. Is there any way to get more than 6 fields.

T.I.A.

3 replies

by dklippert

Microsoft Graph is included with any Office suite. It is not a separately installed app.

Create the Graph using data from a Query.
If you use the Wizard you are limited to 6 fields, but after you have created the graph, click once on the chart.Then Right click to bring up the Properties. On the Data tab look at the Source. It should look a bit like this:

SELECT [Field1],[Field2] FROM [Query1];

Edit this and you can add more than six fields. Such as:

SELECT
[Field1],[Field2],[Field3],[Field4],[Field5],[Field6],[Field7],[Field8] FROM
[Query1];

This discussion is closed to new replies.