Is it possible to apply conditional formating to a pivot chart?
 

I saw a similar question that asked about applying conditional formatting to
a chart, and i tried applying that "technique" to a pivot chart, but it
didn't return the same results.

Does anyone know if it's possible to actually apply the conditional
formatting to a pivot chart?

Thanks!

Is it possible to apply conditional formating to a pivot chart?
 

Pivot charts are a real bummer with formatting. Any change to the underlying
table resets the formatting. Microsoft admits that it's a problem, and the
problem persists from Excel 2000 through 2003:

Changing a PivotChart Removes Series Formatting (215904)
http://support.microsoft.com/default...;EN-US;Q215904

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"lay" wrote in message
...
I saw a similar question that asked about applying conditional formatting
to
a chart, and i tried applying that "technique" to a pivot chart, but it
didn't return the same results.

Does anyone know if it's possible to actually apply the conditional
formatting to a pivot chart?

Thanks!

Is it possible to apply conditional formating to a pivot chart
 

Thanks! i guess i would have to work around it then

"Jon Peltier" wrote:

Pivot charts are a real bummer with formatting. Any change to the underlying
table resets the formatting. Microsoft admits that it's a problem, and the
problem persists from Excel 2000 through 2003:

Changing a PivotChart Removes Series Formatting (215904)
http://support.microsoft.com/default...;EN-US;Q215904

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"lay" wrote in message
...
I saw a similar question that asked about applying conditional formatting
to
a chart, and i tried applying that "technique" to a pivot chart, but it
didn't return the same results.

Does anyone know if it's possible to actually apply the conditional
formatting to a pivot chart?

Thanks!

Is it possible to apply conditional formating to a pivot chart
 

question is, reformatting it after refreshing the table aside, is it possible
to have some sort of conditional formatting applied to the "original" pivot
chart so that if say, my value goes down below a certain number, the marker
for the pivot chart changes to a different color??

like the example from your website that was applied to regular charts.
http://peltiertech.com/Excel/Charts/...nalChart1.html



"Jon Peltier" wrote:

Pivot charts are a real bummer with formatting. Any change to the underlying
table resets the formatting. Microsoft admits that it's a problem, and the
problem persists from Excel 2000 through 2003:

Changing a PivotChart Removes Series Formatting (215904)
http://support.microsoft.com/default...;EN-US;Q215904

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"lay" wrote in message
...
I saw a similar question that asked about applying conditional formatting
to
a chart, and i tried applying that "technique" to a pivot chart, but it
didn't return the same results.

Does anyone know if it's possible to actually apply the conditional
formatting to a pivot chart?

Thanks!

Is it possible to apply conditional formating to a pivot chart
 

Since the approach on my example uses additional ranges, you could set up
ranges with formulas outside the pivot table, and make a regular chart using
these ranges. I rarely use pivot charts, preferring regular charts for their
greater flexibility.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"lay" wrote in message
...
question is, reformatting it after refreshing the table aside, is it
possible
to have some sort of conditional formatting applied to the "original"
pivot
chart so that if say, my value goes down below a certain number, the
marker
for the pivot chart changes to a different color??

like the example from your website that was applied to regular charts.
http://peltiertech.com/Excel/Charts/...nalChart1.html



"Jon Peltier" wrote:

Pivot charts are a real bummer with formatting. Any change to the
underlying
table resets the formatting. Microsoft admits that it's a problem, and
the
problem persists from Excel 2000 through 2003:

Changing a PivotChart Removes Series Formatting (215904)
http://support.microsoft.com/default...;EN-US;Q215904

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"lay" wrote in message
...
I saw a similar question that asked about applying conditional
formatting
to
a chart, and i tried applying that "technique" to a pivot chart, but it
didn't return the same results.

Does anyone know if it's possible to actually apply the conditional
formatting to a pivot chart?

Thanks!

Is it possible to apply conditional formating to a pivot chart
 

The thing is, i'm importing my data from a database in access so that any
changes made in access would be reflected in the charts in excel. And i think
pivot tables are the only one that will allow that.

"Jon Peltier" wrote:

Since the approach on my example uses additional ranges, you could set up
ranges with formulas outside the pivot table, and make a regular chart using
these ranges. I rarely use pivot charts, preferring regular charts for their
greater flexibility.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"lay" wrote in message
...
question is, reformatting it after refreshing the table aside, is it
possible
to have some sort of conditional formatting applied to the "original"
pivot
chart so that if say, my value goes down below a certain number, the
marker
for the pivot chart changes to a different color??

like the example from your website that was applied to regular charts.
http://peltiertech.com/Excel/Charts/...nalChart1.html



"Jon Peltier" wrote:

Pivot charts are a real bummer with formatting. Any change to the
underlying
table resets the formatting. Microsoft admits that it's a problem, and
the
problem persists from Excel 2000 through 2003:

Changing a PivotChart Removes Series Formatting (215904)
http://support.microsoft.com/default...;EN-US;Q215904

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"lay" wrote in message
...
I saw a similar question that asked about applying conditional
formatting
to
a chart, and i tried applying that "technique" to a pivot chart, but it
didn't return the same results.

Does anyone know if it's possible to actually apply the conditional
formatting to a pivot chart?

Thanks!

Is it possible to apply conditional formating to a pivot chart
 

Well, you could revert to a VBA approach to color the points according to
your criteria. Or you could make the columns my approach uses large enough
to accommodate the largest pivot table you would ever get, and use dynamic
ranges to define the size of the series in the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"lay" wrote in message
...
The thing is, i'm importing my data from a database in access so that any
changes made in access would be reflected in the charts in excel. And i
think
pivot tables are the only one that will allow that.

"Jon Peltier" wrote:

Since the approach on my example uses additional ranges, you could set up
ranges with formulas outside the pivot table, and make a regular chart
using
these ranges. I rarely use pivot charts, preferring regular charts for
their
greater flexibility.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"lay" wrote in message
...
question is, reformatting it after refreshing the table aside, is it
possible
to have some sort of conditional formatting applied to the "original"
pivot
chart so that if say, my value goes down below a certain number, the
marker
for the pivot chart changes to a different color??

like the example from your website that was applied to regular charts.
http://peltiertech.com/Excel/Charts/...nalChart1.html



"Jon Peltier" wrote:

Pivot charts are a real bummer with formatting. Any change to the
underlying
table resets the formatting. Microsoft admits that it's a problem, and
the
problem persists from Excel 2000 through 2003:

Changing a PivotChart Removes Series Formatting (215904)
http://support.microsoft.com/default...;EN-US;Q215904

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"lay" wrote in message
...
I saw a similar question that asked about applying conditional
formatting
to
a chart, and i tried applying that "technique" to a pivot chart, but
it
didn't return the same results.

Does anyone know if it's possible to actually apply the conditional
formatting to a pivot chart?

Thanks!

Is it possible to apply conditional formating to a pivot chart
 

ok, i tried using your suggestion and applied the "conditional" ranges
outside of my pivot table, but i can't get it to paste on my pivot chart!
I'll click on "paste special" but then, nothing. Grrrrrrr!!! we should all
just revert back to the good ol fashion pen and paper!!!

Thank you so much for all your help, jon!

"Jon Peltier" wrote:

Well, you could revert to a VBA approach to color the points according to
your criteria. Or you could make the columns my approach uses large enough
to accommodate the largest pivot table you would ever get, and use dynamic
ranges to define the size of the series in the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"lay" wrote in message
...
The thing is, i'm importing my data from a database in access so that any
changes made in access would be reflected in the charts in excel. And i
think
pivot tables are the only one that will allow that.

"Jon Peltier" wrote:

Since the approach on my example uses additional ranges, you could set up
ranges with formulas outside the pivot table, and make a regular chart
using
these ranges. I rarely use pivot charts, preferring regular charts for
their
greater flexibility.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"lay" wrote in message
...
question is, reformatting it after refreshing the table aside, is it
possible
to have some sort of conditional formatting applied to the "original"
pivot
chart so that if say, my value goes down below a certain number, the
marker
for the pivot chart changes to a different color??

like the example from your website that was applied to regular charts.
http://peltiertech.com/Excel/Charts/...nalChart1.html



"Jon Peltier" wrote:

Pivot charts are a real bummer with formatting. Any change to the
underlying
table resets the formatting. Microsoft admits that it's a problem, and
the
problem persists from Excel 2000 through 2003:

Changing a PivotChart Removes Series Formatting (215904)
http://support.microsoft.com/default...;EN-US;Q215904

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"lay" wrote in message
...
I saw a similar question that asked about applying conditional
formatting
to
a chart, and i tried applying that "technique" to a pivot chart, but
it
didn't return the same results.

Does anyone know if it's possible to actually apply the conditional
formatting to a pivot chart?

Thanks!

Is it possible to apply conditional formating to a pivot chart
 

No, not what I said. The ranges outside the pivot table cannot be added to a
pivot chart. Pivot charts only display data in the pivot table. You need to
make a regular chart from a mixture of regular and pivot data. Start with a
blank cell not near the pivot table, start the chart wizard, and in step 2,
click on the Series tab, and add each series separately.

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

"lay" wrote in message
...
ok, i tried using your suggestion and applied the "conditional" ranges
outside of my pivot table, but i can't get it to paste on my pivot chart!
I'll click on "paste special" but then, nothing. Grrrrrrr!!! we should all
just revert back to the good ol fashion pen and paper!!!

Thank you so much for all your help, jon!

"Jon Peltier" wrote:

Well, you could revert to a VBA approach to color the points according to
your criteria. Or you could make the columns my approach uses large
enough
to accommodate the largest pivot table you would ever get, and use
dynamic
ranges to define the size of the series in the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"lay" wrote in message
...
The thing is, i'm importing my data from a database in access so that
any
changes made in access would be reflected in the charts in excel. And i
think
pivot tables are the only one that will allow that.

"Jon Peltier" wrote:

Since the approach on my example uses additional ranges, you could set
up
ranges with formulas outside the pivot table, and make a regular chart
using
these ranges. I rarely use pivot charts, preferring regular charts for
their
greater flexibility.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"lay" wrote in message
...
question is, reformatting it after refreshing the table aside, is it
possible
to have some sort of conditional formatting applied to the
"original"
pivot
chart so that if say, my value goes down below a certain number, the
marker
for the pivot chart changes to a different color??

like the example from your website that was applied to regular
charts.
http://peltiertech.com/Excel/Charts/...nalChart1.html



"Jon Peltier" wrote:

Pivot charts are a real bummer with formatting. Any change to the
underlying
table resets the formatting. Microsoft admits that it's a problem,
and
the
problem persists from Excel 2000 through 2003:

Changing a PivotChart Removes Series Formatting (215904)
http://support.microsoft.com/default...;EN-US;Q215904

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"lay" wrote in message
...
I saw a similar question that asked about applying conditional
formatting
to
a chart, and i tried applying that "technique" to a pivot chart,
but
it
didn't return the same results.

Does anyone know if it's possible to actually apply the
conditional
formatting to a pivot chart?

Thanks!