Graphs in Access

As I stated in your previous post:
>As far as the Conditional formatting is concerned, this may prove difficult to do.
>
>1. Conditional Formatting is not supported currently in MS Access Charts
>2. The Bar color is tied to series.  
>You would have to somehow structure the source data to represent the two different Formatting condtions.
>...or learn VBA Chart/Graph Automation...
>
>IMHO, neither is worth the trouble

That all being said, I am well aware that there are Experts here wo have used Chart/Graph automation to solve issues like this.

Please leave this question open for about 2 weeks, even if you get no bites.

Some experts only log in once a week or so...

;-)

JeffCoachman

Also Please click the "Request Attention" Button and ask that this Q be added to the Excel zone.

Experts there are good at all manner of Chart/Graph Manipulation.

;-)

<So you want all bars over 95% or greater to be Blue, and anything under 95% to be Red?> yes thats the idea !  would be great . P.S. I hate access

I am willing to bet Excel might maybe possibly can support this. Otherwise, a custom approach might work, as your chart seems pretty basic. SOME CODING REQUIRED. Game? Post sample of db with non-sensitive, small size,with represenative data for at least one red and one blue bar, and rules for determining percent.

Ok  Here is waht i have so far with some static info just to see it working.. I wanted everything under 95% in red and everything over in blue.  MSAccess need to step up there game. thanks for taking a look at this
db1rev.zip

Thanks for coming in on this Jerry.
;-)

Jeff

Jerry,

LOL

I always for get about this technique.
I use Rectangles.
What are you using that your tops are rounded?

Jeff

vba.
Access report.
I use the quick and dirty.
Attached.
I think rectangle is available in vb.If available in vba, then I forgot how.
db1rev.zip

I can get you the same thing only Horizontally.
(Which may be better if you add more datapoints.)

If you are as eager about learning VBA and charting as you say, then it should be easy for you to customize either example. (ex. Insert Lables at the end of the bars based on the bar length)
;-)

Let us know
untitled.JPG

Oh,
I just drop the records on the report and size a Rectangle based on a Factor of the Max value
Quicker perhaps, and less VBA.
But probably less flexible?

Jeff
Access-EEQ24580191SimulatedBarCh.mdb

Ah, the old boxCanGrow technique. (I think.) First thing that brought me me to ee, in a round-about way. Which I also still use.
Thanks for the reminder.

I still think I did something early here to get a vertical rectangle. 3-4 years ago. (?)
Useful for me to use, so I do not mind the time spent re-learning. Value of trying things on ee.
Less flexible? Maybe.
Gotta check my old answers.

LOL, I got lost at "I use Rectangles" but I see its not going to be as easy as it looks. I cant use reports because I am embedding this into a top form to show different metrics.  I will have to make due with what I have but thanks for help not a huge deal I am more concern about getting my 4th metric done....
metric.JPG

LOL,

That "Dashboard" screenshot is very popular.

everyone wants to emulate it, without actually buying the product...
;-)

Jeff

Jerry, Thanks tor the sample file.
It adds another tool to my toolbox...

Jeff

I bought the product .. well worth the money but some what limited. I have to do a lot of tweaking to get what I need but very helpful

;-)

jeff:
yet another reason to work here.
can you come back at me? I have lost a lot of older stuff due to catastrophic dual drive failure.
thanks.
jerry

Oh, you did. sorry.

<can you come back at me?>
?
Translation please?

I meant sample, too, which you did in fact post.......

;-)

OK