Is it possible to have part of the chart print in red?

D

Dot

I typed weights into an Excel document then made a
chart. Is there any way to make the chart print certain
weights in a different color? For example, could I get
it to make any weight over 500 grams show up in red?

Dot
 
D

Dot

Thanks. I tried the easiest one but wasn't able to make
it work. It had an X and Y axis and I only have one
number. I'll keep working on it.
Dot
 
D

Debra Dalgleish

Assuming your weights are in column B, you could add formulas in columns
C and D, to calculate the series.

In cell C2, enter: =IF(B2<500,B2,NA())
In cell D2, enter: =IF(B2>=500,B2,NA())

Copy the formulas down to the last row of data.
Select the headings cells and data in column A
Hold the Ctrl key, and select the heading cells and data in columns C:D
Click the Chart Wizard button, and create a stacked column chart.

Weight <500 >=500
7/1/04 706 #N/A 706
7/2/04 533 #N/A 533
 
D

Debra Dalgleish

Yes, just change the row references in the formulas, e.g.:

=IF(B3<500,B3,NA())
and
=IF(B3>=500,B3,NA())
 
D

Debra Dalgleish

If you hit Enter, usually you move down one cell
You could also press the Tab key, to move to the right

Select cell C3, and type the formula:
=IF(B3<500,B3,NA())
then press the Tab key, to move to cell D3

In cell D3, type the formula:
=IF(B3>=500,B3,NA())
Press the Enter key, to complete the entry

To copy the formulas down, select cells C3 and D3
Point to the Fill Handle, the small black square at the bottom right of
the selection.
When the pointer changes to a black cross, drag down to the last row of
data.
 
Top