This content has been marked as final. Show 5 replies
Try the attached.
Thanks for the reply but I'm getting an error now. Attached is the error and line it is complaining about.
Thanks again for your assistance, it is GREATLY appreciated.
I figured out the problem noted in my previous post. The WHERE need single quoutes not double.
But I am still getting all the Originators and the In and Out TQs stacked on top of each other instead of side-by-side.
I modified the code as follows to change the stacked graph to default, this allows the Originators to display side-by-side but also the In or Out TQs also display side-by-side instead of stacked on top of each other. I removed the color specification I used because it made it difficult to see which Originator's In/Out TQs I was looking at.
If you have any other ideas, I'm willing to try them...
BTW -- I'm implementing a bunch of these graphs and keep coming up against the same type of problem when the data returned is more complex. Do you know of a good resource for learning CFCharts and how to manipulate complex data queries in them? I've gone through SEVERAL books and tutorials and I can recreate their examples, but they are too simple for most of the reporting I'm trying to graph.
Again, thanks and thanks!
Unfortunately, the combination of stacked and clustered bars you want is beyond the capabilities of CFChart.
CFChart can really only do basic charts. It runs a subset(!) of Webcharts3D and that engine is pretty limited.
Look up webchart designer in these forums and in CF help. You'll find a tool that will show you CFchart's possibilities.
Alas, I can't think of a good way, to display the information you have, that cfchart can do.
We use ChartDirector ( http://www.advsofteng.com) for engineering and scientific charts. However, this does require C or java integration.
As for books, your best bet is The Visual Display of Quantitative Information .
Thanks for the information MikeRoo. And THANKS for your help.