Conditional charts

J

Jeff

Is there a way to change the color of a chart bar based on the value of the
cell that generates that particular bar? In other words, I have a chart
with 15 vertical bars and I want to change the color of one or more of the
bars if its value goes above 100% (but not all of the bars).

JWeinberg
 
J

Jeff

Thanks Jon. A great help. One other question. How do I keep drawn lines
and text boxes on charts from disappearing when I either click on the chart
itself or off the chart? Some lines and text I add to the chart stays
there, others don't. I spend most of my time "fighting" with Excel to get
the chart to be what I want it to be.

JWeinberg
 
D

Debra Dalgleish

If you want to add a drawing object to a chart, select the chart first.

When the chart is selected, it will have selection handles -- small
black boxes (or white circles) at the corners and on the sides.

With the chart selected, you can add text boxes, lines, etc., and
they'll remain visible.

If the chart is not selected, and you draw objects on top of it, the
objects will be hidden when you activate the chart.
 
J

Jeff

Thank you Debra.

Jeff

Debra Dalgleish said:
If you want to add a drawing object to a chart, select the chart first.

When the chart is selected, it will have selection handles -- small
black boxes (or white circles) at the corners and on the sides.

With the chart selected, you can add text boxes, lines, etc., and
they'll remain visible.

If the chart is not selected, and you draw objects on top of it, the
objects will be hidden when you activate the chart.
Click to expand...
 
Top