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

  • Thread starter Thread starter Dot
  • Start date Start date
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
 
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
 
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
 
Yes, just change the row references in the formulas, e.g.:

=IF(B3<500,B3,NA())
and
=IF(B3>=500,B3,NA())
 
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.
 
Back
Top