Charting Two Items - Microsoft Access Forum


	Back to Access Forum Comments List

Charting Two Items

James Hopkins

2 years ago

Hey Richard and the Guys, I am trying to figure out how display the Contract Type vs Status in a Line Chart. I have created an "Contract Status Query" that I am using to get the Count and Amount Per Status and a "Contract Type Query" that I am using to get the Count and Amount Per Type which both are used in two different Charts. What is the best way to achieve this?

	James Hopkins OP @Reply 2 years ago

	Richard Rost @Reply 2 years ago
You're looking for the axes labels?

	Sami Shamma @Reply 2 years ago
Have you tried combining them in one cross table query?

	James Hopkins OP @Reply 2 years ago
Yes, Richard and Sami

	Richard Rost @Reply 2 years ago
If memory serves, that's one of the things I couldn't find either when I was playing with modern charts, although they might have added them since then to the properties. But I'm in my car right now, so I can't easily check. Take a look down the property list and see if they added them.

John Campbell @Reply

2 years ago

I think what you are asking is can you have two Y axis's?  I took this data to graph in both Excel and Access.  Excel allows for a Y1 and Y2 Axis.  So if I am plotting the below data, the Gas can be on the Y1 axis and the Electric Values can be on the Y2 Axis.
MS Access does not allow for 2 y axis'.  You can plot the below together, but only for one axis.  Hope this helps.
MonthGasElectric
Feb         3355
Mar         4523
Apr         2232
May         1611
Jun         6512

	James Hopkins OP @Reply 2 years ago
Yes, correct John. I am try to display the Number of Contract's Status versus Type. I guess I need to create an Crosstab Query to combine the two Queries I have for the Type and the Status.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen