Column Chart

[Caribeiro77]

Hy,
Is it possible to give diferent colours just to the highest and the smallest values in a column chart (for example red to the column that represents the smallest value and green to column that represents the highest value), and all the other colmuns stays in the default excel column chart colour.
Thanks

 

[Robert Mika]

You can definitely change that manualy if that is what you are asking for.

 

[CWatts]

Check out this dueling podcast to give you a couple of options:

http://www.youtube.com/watch?v=_cyIN4oxibw

 

[Caribeiro77]

I don't realy need positive and negative values showned with diferent colours.
I have a chart with revenues per month, and what i need is the month with the lowest revenue in red and the month with the higher revenue value in green.
Thanks

 

[CWatts]

The criteria used in the video is irrelevant. It's the method that's important. Instead of testing if it's positive or negative, text if the value is equal to the minimum or not. Then do your stacked chart from A9:C14.

Sheet1

<table style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; " border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td> </td><td>A</td><td>B</td><td>C</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">1</td><td style="font-weight:bold; ">Name</td><td style="font-weight:bold; text-align:center; ">Amount</td><td> </td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">2</td><td>Bill</td><td style="text-align:center; ">5</td><td> </td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">3</td><td>Bob</td><td style="text-align:center; ">4</td><td> </td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">4</td><td>Sue</td><td style="text-align:center; ">4</td><td> </td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">5</td><td>Sally</td><td style="text-align:center; ">1</td><td> </td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">6</td><td>Steve</td><td style="text-align:center; ">8</td><td> </td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">7</td><td> </td><td> </td><td> </td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">8</td><td> </td><td> </td><td> </td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">9</td><td style="font-weight:bold; ">Name</td><td style="font-weight:bold; text-align:center; ">Noraml</td><td style="font-weight:bold; text-align:center; ">Min</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">10</td><td>Bill</td><td style="text-align:center; ">5</td><td>#N/A</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">11</td><td>Bob</td><td style="text-align:center; ">4</td><td>#N/A</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">12</td><td>Sue</td><td style="text-align:center; ">4</td><td>#N/A</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">13</td><td>Sally</td><td>#N/A</td><td style="text-align:center; ">1</td></tr><tr style="height:18px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">14</td><td>Steve</td><td style="text-align:center; ">8</td><td>#N/A</td></tr></tbody></table>
<table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tbody><tr><td>Spreadsheet Formulas</td></tr><tr><td><table style="font-family:Arial; font-size:9pt;" border="1" cellpadding="2" cellspacing="0"><tbody><tr style="background-color:#cacaca; font-size:10pt;"><td>Cell</td><td>Formula</td></tr><tr><td>B10</td><td>=IF(B2<>MIN(B$2:B$6),B2,NA())</td></tr><tr><td>C10</td><td>=IF(B2=MIN(B$2:B$6),B2,NA())</td></tr><tr><td>B11</td><td>=IF(B3<>MIN(B$2:B$6),B3,NA())</td></tr><tr><td>C11</td><td>=IF(B3=MIN(B$2:B$6),B3,NA())</td></tr><tr><td>B12</td><td>=IF(B4<>MIN(B$2:B$6),B4,NA())</td></tr><tr><td>C12</td><td>=IF(B4=MIN(B$2:B$6),B4,NA())</td></tr><tr><td>B13</td><td>=IF(B5<>MIN(B$2:B$6),B5,NA())</td></tr><tr><td>C13</td><td>=IF(B5=MIN(B$2:B$6),B5,NA())</td></tr><tr><td>B14</td><td>=IF(B6<>MIN(B$2:B$6),B6,NA())</td></tr><tr><td>C14</td><td>=IF(B6=MIN(B$2:B$6),B6,NA())</td></tr></tbody></table></td></tr></tbody></table>

 

[Caribeiro77]

Problem solved...
Thanks

The criteria used in the video is irrelevant. It's the method that's important. Instead of testing if it's positive or negative, text if the value is equal to the minimum or not. Then do your stacked chart from A9:C14.

Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="FONT-WEIGHT: bold">Name</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Amount</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD>Bill</TD><TD style="TEXT-ALIGN: center">5</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD>Bob</TD><TD style="TEXT-ALIGN: center">4</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD>Sue</TD><TD style="TEXT-ALIGN: center">4</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD>Sally</TD><TD style="TEXT-ALIGN: center">1</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD>Steve</TD><TD style="TEXT-ALIGN: center">8</TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="FONT-WEIGHT: bold">Name</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Noraml</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Min</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD>Bill</TD><TD style="TEXT-ALIGN: center">5</TD><TD>#N/A</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD>Bob</TD><TD style="TEXT-ALIGN: center">4</TD><TD>#N/A</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD>Sue</TD><TD style="TEXT-ALIGN: center">4</TD><TD>#N/A</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD>Sally</TD><TD>#N/A</TD><TD style="TEXT-ALIGN: center">1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD>Steve</TD><TD style="TEXT-ALIGN: center">8</TD><TD>#N/A</TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; BORDER-LEFT-STYLE: groove; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>B10</TD><TD>=IF(B2<>MIN(B$2:B$6),B2,NA())</TD></TR><TR><TD>C10</TD><TD>=IF(B2=MIN(B$2:B$6),B2,NA())</TD></TR><TR><TD>B11</TD><TD>=IF(B3<>MIN(B$2:B$6),B3,NA())</TD></TR><TR><TD>C11</TD><TD>=IF(B3=MIN(B$2:B$6),B3,NA())</TD></TR><TR><TD>B12</TD><TD>=IF(B4<>MIN(B$2:B$6),B4,NA())</TD></TR><TR><TD>C12</TD><TD>=IF(B4=MIN(B$2:B$6),B4,NA())</TD></TR><TR><TD>B13</TD><TD>=IF(B5<>MIN(B$2:B$6),B5,NA())</TD></TR><TR><TD>C13</TD><TD>=IF(B5=MIN(B$2:B$6),B5,NA())</TD></TR><TR><TD>B14</TD><TD>=IF(B6<>MIN(B$2:B$6),B6,NA())</TD></TR><TR><TD>C14</TD><TD>=IF(B6=MIN(B$2:B$6),B6,NA())</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

 

[CWatts]

Glad it worked and you could decipher my terrible typos!