conditional "bar chart"?

mcgraw

Registered User.
Local time
Today, 12:54
Joined
Nov 13, 2009
Messages
77
I'd like to know if it is possible to setup a bar chart with conditions?

What we want is if the field with_group:

= group1, have the bar go out to a certain point on the x axis.
= group2, have the bar go further out on the x axis
= group3, have the bar go even further out
(and so on and so forth)

And then have the different groups listed across the top as a legend.

It's sort of like a progress tracker, so people can see how far along in the process a system is.

Anyone have an example of how to do this?
 
This may help...I got this after searching "stacked bar charts" in this forum.

"The MS Graph engine that powers charts in Access and Excel is extremely flexible, but it often requires some tinkering. Doug Den Hoed shares his techniques for building Gantt charts, and he reveals some tricks to help you make your charts look more professional."
http://www.smartaccessnewsletter.com...tart=9.2&Seq=4


He did a Gantt chart as a stacked bar chart and shows the use of a query as the basis of the chart
 
apparently the link isnt working...I'll see what else I can find for you.
 

Users who are viewing this thread

Back
Top Bottom