Conditional Formatting for a Column Chart and Auto Shape
 

I have a worksheet that evaluates the % of a goal. I have it set up as a
chart and autoshape (to look like a thermometer).

Currently, I have one cell that changes colors based on the comparison
between their goal and where they are at....this is the information that
fills the chart....however I can't figure out how to change the chart color
like the cell.

Conditional Formatting for a Column Chart and Auto Shape
 

Hi Amanda,

There is no equivalent thing in the chart area for conditional formatting,
however, with a little work you can create a chart that duplicates what you
want. But before I try to ddo that - exactly what do you want - do you want
the entire column to change color after they reach some target or do you want
the amount above the target to show as a different color than the amount
below the target?

--
Thanks,
Shane Devenshire


"Amanda" wrote:

I have a worksheet that evaluates the % of a goal. I have it set up as a
chart and autoshape (to look like a thermometer).

Currently, I have one cell that changes colors based on the comparison
between their goal and where they are at....this is the information that
fills the chart....however I can't figure out how to change the chart color
like the cell.

Conditional Formatting for a Column Chart and Auto Shape
 

If they are <1% of the goal, red.....equal to or between -1% & 1%
yellow.....and more than 1% green

"ShaneDevenshire" wrote:

Hi Amanda,

There is no equivalent thing in the chart area for conditional formatting,
however, with a little work you can create a chart that duplicates what you
want. But before I try to ddo that - exactly what do you want - do you want
the entire column to change color after they reach some target or do you want
the amount above the target to show as a different color than the amount
below the target?

--
Thanks,
Shane Devenshire


"Amanda" wrote:

I have a worksheet that evaluates the % of a goal. I have it set up as a
chart and autoshape (to look like a thermometer).

Currently, I have one cell that changes colors based on the comparison
between their goal and where they are at....this is the information that
fills the chart....however I can't figure out how to change the chart color
like the cell.

Conditional Formatting for a Column Chart and Auto Shape
 

"Amanda" wrote in message
...
I have a worksheet that evaluates the % of a goal. I have it set up as a
chart and autoshape (to look like a thermometer).

Currently, I have one cell that changes colors based on the comparison
between their goal and where they are at....this is the information that
fills the chart....however I can't figure out how to change the chart
color
like the cell.

Conditional Formatting for a Column Chart and Auto Shape
 

Amanda -

This web site may get you started:

http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Amanda" wrote in message
...
If they are <1% of the goal, red.....equal to or between -1% & 1%
yellow.....and more than 1% green

"ShaneDevenshire" wrote:

Hi Amanda,

There is no equivalent thing in the chart area for conditional
formatting,
however, with a little work you can create a chart that duplicates what
you
want. But before I try to ddo that - exactly what do you want - do you
want
the entire column to change color after they reach some target or do you
want
the amount above the target to show as a different color than the amount
below the target?

--
Thanks,
Shane Devenshire


"Amanda" wrote:

I have a worksheet that evaluates the % of a goal. I have it set up as
a
chart and autoshape (to look like a thermometer).

Currently, I have one cell that changes colors based on the comparison
between their goal and where they are at....this is the information
that
fills the chart....however I can't figure out how to change the chart
color
like the cell.

Conditional Formatting for a Column Chart and Auto Shape
 

I looked at the link, but I do'n't see how that will help my chart. I only
have one column, not multiples, and I need the color to change based on an
outside cell.

Also, I can't download the zip file to see how the column chart was created,
because it is blocked by my work.

Any ideas? Am I wrong that it wouldn't work?

"Jon Peltier" wrote:

Amanda -

This web site may get you started:

http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Amanda" wrote in message
...
If they are <1% of the goal, red.....equal to or between -1% & 1%
yellow.....and more than 1% green

"ShaneDevenshire" wrote:

Hi Amanda,

There is no equivalent thing in the chart area for conditional
formatting,
however, with a little work you can create a chart that duplicates what
you
want. But before I try to ddo that - exactly what do you want - do you
want
the entire column to change color after they reach some target or do you
want
the amount above the target to show as a different color than the amount
below the target?

--
Thanks,
Shane Devenshire


"Amanda" wrote:

I have a worksheet that evaluates the % of a goal. I have it set up as
a
chart and autoshape (to look like a thermometer).

Currently, I have one cell that changes colors based on the comparison
between their goal and where they are at....this is the information
that
fills the chart....however I can't figure out how to change the chart
color
like the cell.

Conditional Formatting for a Column Chart and Auto Shape
 

I think I figured it out....based on the website you gave me and one other I
found online....however, now there is this ugly table in the middle of my
sheet....and when I hide it, it hides my chart....HELP!

"Amanda" wrote:

I looked at the link, but I do'n't see how that will help my chart. I only
have one column, not multiples, and I need the color to change based on an
outside cell.

Also, I can't download the zip file to see how the column chart was created,
because it is blocked by my work.

Any ideas? Am I wrong that it wouldn't work?

"Jon Peltier" wrote:

Amanda -

This web site may get you started:

http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Amanda" wrote in message
...
If they are <1% of the goal, red.....equal to or between -1% & 1%
yellow.....and more than 1% green

"ShaneDevenshire" wrote:

Hi Amanda,

There is no equivalent thing in the chart area for conditional
formatting,
however, with a little work you can create a chart that duplicates what
you
want. But before I try to ddo that - exactly what do you want - do you
want
the entire column to change color after they reach some target or do you
want
the amount above the target to show as a different color than the amount
below the target?

--
Thanks,
Shane Devenshire


"Amanda" wrote:

I have a worksheet that evaluates the % of a goal. I have it set up as
a
chart and autoshape (to look like a thermometer).

Currently, I have one cell that changes colors based on the comparison
between their goal and where they are at....this is the information
that
fills the chart....however I can't figure out how to change the chart
color
like the cell.

Conditional Formatting for a Column Chart and Auto Shape
 

Move the table out of view, or select the chart, go to Tools menu Options
Chart tab, and uncheck Plot Visible Cells Only.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Amanda" wrote in message
...
I think I figured it out....based on the website you gave me and one other
I
found online....however, now there is this ugly table in the middle of my
sheet....and when I hide it, it hides my chart....HELP!

"Amanda" wrote:

I looked at the link, but I do'n't see how that will help my chart. I
only
have one column, not multiples, and I need the color to change based on
an
outside cell.

Also, I can't download the zip file to see how the column chart was
created,
because it is blocked by my work.

Any ideas? Am I wrong that it wouldn't work?

"Jon Peltier" wrote:

Amanda -

This web site may get you started:

http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Amanda" wrote in message
...
If they are <1% of the goal, red.....equal to or between -1% & 1%
yellow.....and more than 1% green

"ShaneDevenshire" wrote:

Hi Amanda,

There is no equivalent thing in the chart area for conditional
formatting,
however, with a little work you can create a chart that duplicates
what
you
want. But before I try to ddo that - exactly what do you want - do
you
want
the entire column to change color after they reach some target or do
you
want
the amount above the target to show as a different color than the
amount
below the target?

--
Thanks,
Shane Devenshire


"Amanda" wrote:

I have a worksheet that evaluates the % of a goal. I have it set
up as
a
chart and autoshape (to look like a thermometer).

Currently, I have one cell that changes colors based on the
comparison
between their goal and where they are at....this is the
information
that
fills the chart....however I can't figure out how to change the
chart
color
like the cell.

Conditional Formatting for a Column Chart and Auto Shape
 

Thanks! I moved it out of view and it works perfectly. I did not know about
the "Plot visible cells only" that will help on future projects!

Thanks again

"Jon Peltier" wrote:

Move the table out of view, or select the chart, go to Tools menu Options
Chart tab, and uncheck Plot Visible Cells Only.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Amanda" wrote in message
...
I think I figured it out....based on the website you gave me and one other
I
found online....however, now there is this ugly table in the middle of my
sheet....and when I hide it, it hides my chart....HELP!

"Amanda" wrote:

I looked at the link, but I do'n't see how that will help my chart. I
only
have one column, not multiples, and I need the color to change based on
an
outside cell.

Also, I can't download the zip file to see how the column chart was
created,
because it is blocked by my work.

Any ideas? Am I wrong that it wouldn't work?

"Jon Peltier" wrote:

Amanda -

This web site may get you started:

http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Amanda" wrote in message
...
If they are <1% of the goal, red.....equal to or between -1% & 1%
yellow.....and more than 1% green

"ShaneDevenshire" wrote:

Hi Amanda,

There is no equivalent thing in the chart area for conditional
formatting,
however, with a little work you can create a chart that duplicates
what
you
want. But before I try to ddo that - exactly what do you want - do
you
want
the entire column to change color after they reach some target or do
you
want
the amount above the target to show as a different color than the
amount
below the target?

--
Thanks,
Shane Devenshire


"Amanda" wrote:

I have a worksheet that evaluates the % of a goal. I have it set
up as
a
chart and autoshape (to look like a thermometer).

Currently, I have one cell that changes colors based on the
comparison
between their goal and where they are at....this is the
information
that
fills the chart....however I can't figure out how to change the
chart
color
like the cell.