By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

Two chart questions

P: n/a
I have two related chart problems.

I have a simple chart which shows waste in a manufacturing process.

On a basic bar chart we show waste percentage by day, I would like to be
able to add the following to the chart

1. draw a line across the chart at the acceptable waste level, which is a
global variable (4.5 at the moment)

2. Have any dates that are over that level to show the bars in red, and ay
dates below that level in green.
TIA
Steven
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
SA
Steve:

1.) Drawn line: Add a separate series to your graph which is the same
number across all items. Using the data series properties, (click on one of
the bars,) narrow the bar width for the series to 0 to make it non-visible,
then add trendline for that series to the graph with the intercept set to
the same value.

2.) If you stop by our web and look in the Code and Design Tips area under
reports, you'll find a topic called Common Problems with Graph. If you look
at the fourth item in that tip, you'llget the answer to your question #2.

--
Steve Arbaugh
MS Access MVP
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg
"Steven Malcolm" <mi***********@ozemail.com.au> wrote in message
news:qQ*****************@nnrp1.ozemail.com.au...
I have two related chart problems.

I have a simple chart which shows waste in a manufacturing process.

On a basic bar chart we show waste percentage by day, I would like to be
able to add the following to the chart

1. draw a line across the chart at the acceptable waste level, which is a
global variable (4.5 at the moment)

2. Have any dates that are over that level to show the bars in red, and ay
dates below that level in green.
TIA
Steven

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.