Graphs in Access

Gabe Lebron
Gabe Lebron used Ask the Experts™
on
I have a chart that shows percent I would like some conditional format where is shows blue and anything under 95% shows red but where can i set this?
chart.JPG
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
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
MIS Liason
Most Valuable Expert 2012
Commented:
But just to be clear...
<where is shows blue and anything under 95% shows red>
So you want all bars over 95% or greater to be Blue, and anything under 95% to be Red?
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
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.

;-)
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
<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

Commented:
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.

Author

Commented:
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
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Thanks for coming in on this Jerry.
;-)

Jeff
Commented:
Here's a chop at it.  From provided data.
A report, not form chart.
No labelling of who, pct, onTime
Rounding at top of line is something I need to fix, too.
I think it will scale, too.
Might be more trouble than it is worth, if you need to do many variations.



newReport.doc
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Jerry,

LOL

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

Jeff

Commented:
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
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
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
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
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

Commented:
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.

Commented:
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.

Author

Commented:
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
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
LOL,

That "Dashboard" screenshot is very popular.

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

Jeff
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

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

Jeff

Author

Commented:
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
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
;-)

Commented:
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

Commented:
Oh, you did. sorry.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

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

Commented:
I meant sample, too, which you did in fact post.......
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
;-)

OK

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial