Conditional charts

  • Thread starter Thread starter Jeff
  • Start date Start date
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
 
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
 
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.
 
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...
 
Back
Top