software

I saw a similar question that asked about applying conditional formatting to
a chart, and i tried applying that quot;techniquequot; 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!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)
support.microsoft.com/default...;EN-US;Q215904

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

quot;layquot; gt; wrote in message
news
gt;I saw a similar question that asked about applying conditional formatting
gt;to
gt; a chart, and i tried applying that quot;techniquequot; to a pivot chart, but it
gt; didn't return the same results.
gt;
gt; Does anyone know if it's possible to actually apply the conditional
gt; formatting to a pivot chart?
gt;
gt; Thanks!
gt;
Thanks! i guess i would have to work around it then

quot;Jon Peltierquot; wrote:

gt; Pivot charts are a real bummer with formatting. Any change to the underlying
gt; table resets the formatting. Microsoft admits that it's a problem, and the
gt; problem persists from Excel 2000 through 2003:
gt;
gt; Changing a PivotChart Removes Series Formatting (215904)
gt; support.microsoft.com/default...;EN-US;Q215904
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; PeltierTech.com/
gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; _______
gt;
gt; quot;layquot; gt; wrote in message
gt; news
gt; gt;I saw a similar question that asked about applying conditional formatting
gt; gt;to
gt; gt; a chart, and i tried applying that quot;techniquequot; to a pivot chart, but it
gt; gt; didn't return the same results.
gt; gt;
gt; gt; Does anyone know if it's possible to actually apply the conditional
gt; gt; formatting to a pivot chart?
gt; gt;
gt; gt; Thanks!
gt; gt;
gt;
gt;
gt;

question is, reformatting it after refreshing the table aside, is it possible
to have some sort of conditional formatting applied to the quot;originalquot; 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.
peltiertech.com/Excel/Charts/...nalChart1.html
quot;Jon Peltierquot; wrote:

gt; Pivot charts are a real bummer with formatting. Any change to the underlying
gt; table resets the formatting. Microsoft admits that it's a problem, and the
gt; problem persists from Excel 2000 through 2003:
gt;
gt; Changing a PivotChart Removes Series Formatting (215904)
gt; support.microsoft.com/default...;EN-US;Q215904
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; PeltierTech.com/
gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; _______
gt;
gt; quot;layquot; gt; wrote in message
gt; news
gt; gt;I saw a similar question that asked about applying conditional formatting
gt; gt;to
gt; gt; a chart, and i tried applying that quot;techniquequot; to a pivot chart, but it
gt; gt; didn't return the same results.
gt; gt;
gt; gt; Does anyone know if it's possible to actually apply the conditional
gt; gt; formatting to a pivot chart?
gt; gt;
gt; gt; Thanks!
gt; gt;
gt;
gt;
gt;

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 -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;layquot; gt; wrote in message
...
gt; question is, reformatting it after refreshing the table aside, is it
gt; possible
gt; to have some sort of conditional formatting applied to the quot;originalquot;
gt; pivot
gt; chart so that if say, my value goes down below a certain number, the
gt; marker
gt; for the pivot chart changes to a different color??
gt;
gt; like the example from your website that was applied to regular charts.
gt; peltiertech.com/Excel/Charts/...nalChart1.html
gt;
gt;
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt; Pivot charts are a real bummer with formatting. Any change to the
gt;gt; underlying
gt;gt; table resets the formatting. Microsoft admits that it's a problem, and
gt;gt; the
gt;gt; problem persists from Excel 2000 through 2003:
gt;gt;
gt;gt; Changing a PivotChart Removes Series Formatting (215904)
gt;gt; support.microsoft.com/default...;EN-US;Q215904
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt;gt; PeltierTech.com/
gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt;gt; _______
gt;gt;
gt;gt; quot;layquot; gt; wrote in message
gt;gt; news
gt;gt; gt;I saw a similar question that asked about applying conditional
gt;gt; gt;formatting
gt;gt; gt;to
gt;gt; gt; a chart, and i tried applying that quot;techniquequot; to a pivot chart, but it
gt;gt; gt; didn't return the same results.
gt;gt; gt;
gt;gt; gt; Does anyone know if it's possible to actually apply the conditional
gt;gt; gt; formatting to a pivot chart?
gt;gt; gt;
gt;gt; gt; Thanks!
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
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.

quot;Jon Peltierquot; wrote:

gt; Since the approach on my example uses additional ranges, you could set up
gt; ranges with formulas outside the pivot table, and make a regular chart using
gt; these ranges. I rarely use pivot charts, preferring regular charts for their
gt; greater flexibility.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; PeltierTech.com/
gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; _______
gt;
gt; quot;layquot; gt; wrote in message
gt; ...
gt; gt; question is, reformatting it after refreshing the table aside, is it
gt; gt; possible
gt; gt; to have some sort of conditional formatting applied to the quot;originalquot;
gt; gt; pivot
gt; gt; chart so that if say, my value goes down below a certain number, the
gt; gt; marker
gt; gt; for the pivot chart changes to a different color??
gt; gt;
gt; gt; like the example from your website that was applied to regular charts.
gt; gt; peltiertech.com/Excel/Charts/...nalChart1.html
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Jon Peltierquot; wrote:
gt; gt;
gt; gt;gt; Pivot charts are a real bummer with formatting. Any change to the
gt; gt;gt; underlying
gt; gt;gt; table resets the formatting. Microsoft admits that it's a problem, and
gt; gt;gt; the
gt; gt;gt; problem persists from Excel 2000 through 2003:
gt; gt;gt;
gt; gt;gt; Changing a PivotChart Removes Series Formatting (215904)
gt; gt;gt; support.microsoft.com/default...;EN-US;Q215904
gt; gt;gt;
gt; gt;gt; - Jon
gt; gt;gt; -------
gt; gt;gt; Jon Peltier, Microsoft Excel MVP
gt; gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; gt;gt; PeltierTech.com/
gt; gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; gt;gt; _______
gt; gt;gt;
gt; gt;gt; quot;layquot; gt; wrote in message
gt; gt;gt; news
gt; gt;gt; gt;I saw a similar question that asked about applying conditional
gt; gt;gt; gt;formatting
gt; gt;gt; gt;to
gt; gt;gt; gt; a chart, and i tried applying that quot;techniquequot; to a pivot chart, but it
gt; gt;gt; gt; didn't return the same results.
gt; gt;gt; gt;
gt; gt;gt; gt; Does anyone know if it's possible to actually apply the conditional
gt; gt;gt; gt; formatting to a pivot chart?
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks!
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

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 -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;layquot; gt; wrote in message
...
gt; The thing is, i'm importing my data from a database in access so that any
gt; changes made in access would be reflected in the charts in excel. And i
gt; think
gt; pivot tables are the only one that will allow that.
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt; Since the approach on my example uses additional ranges, you could set up
gt;gt; ranges with formulas outside the pivot table, and make a regular chart
gt;gt; using
gt;gt; these ranges. I rarely use pivot charts, preferring regular charts for
gt;gt; their
gt;gt; greater flexibility.
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt;gt; PeltierTech.com/
gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt;gt; _______
gt;gt;
gt;gt; quot;layquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; question is, reformatting it after refreshing the table aside, is it
gt;gt; gt; possible
gt;gt; gt; to have some sort of conditional formatting applied to the quot;originalquot;
gt;gt; gt; pivot
gt;gt; gt; chart so that if say, my value goes down below a certain number, the
gt;gt; gt; marker
gt;gt; gt; for the pivot chart changes to a different color??
gt;gt; gt;
gt;gt; gt; like the example from your website that was applied to regular charts.
gt;gt; gt; peltiertech.com/Excel/Charts/...nalChart1.html
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Jon Peltierquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Pivot charts are a real bummer with formatting. Any change to the
gt;gt; gt;gt; underlying
gt;gt; gt;gt; table resets the formatting. Microsoft admits that it's a problem, and
gt;gt; gt;gt; the
gt;gt; gt;gt; problem persists from Excel 2000 through 2003:
gt;gt; gt;gt;
gt;gt; gt;gt; Changing a PivotChart Removes Series Formatting (215904)
gt;gt; gt;gt; support.microsoft.com/default...;EN-US;Q215904
gt;gt; gt;gt;
gt;gt; gt;gt; - Jon
gt;gt; gt;gt; -------
gt;gt; gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt;gt; gt;gt; PeltierTech.com/
gt;gt; gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt;gt; gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt;gt; gt;gt; _______
gt;gt; gt;gt;
gt;gt; gt;gt; quot;layquot; gt; wrote in message
gt;gt; gt;gt; news
gt;gt; gt;gt; gt;I saw a similar question that asked about applying conditional
gt;gt; gt;gt; gt;formatting
gt;gt; gt;gt; gt;to
gt;gt; gt;gt; gt; a chart, and i tried applying that quot;techniquequot; to a pivot chart, but
gt;gt; gt;gt; gt; it
gt;gt; gt;gt; gt; didn't return the same results.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Does anyone know if it's possible to actually apply the conditional
gt;gt; gt;gt; gt; formatting to a pivot chart?
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Thanks!
gt;gt; gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
ok, i tried using your suggestion and applied the quot;conditionalquot; ranges
outside of my pivot table, but i can't get it to paste on my pivot chart!
I'll click on quot;paste specialquot; 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!

quot;Jon Peltierquot; wrote:

gt; Well, you could revert to a VBA approach to color the points according to
gt; your criteria. Or you could make the columns my approach uses large enough
gt; to accommodate the largest pivot table you would ever get, and use dynamic
gt; ranges to define the size of the series in the chart.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; PeltierTech.com/
gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; _______
gt;
gt; quot;layquot; gt; wrote in message
gt; ...
gt; gt; The thing is, i'm importing my data from a database in access so that any
gt; gt; changes made in access would be reflected in the charts in excel. And i
gt; gt; think
gt; gt; pivot tables are the only one that will allow that.
gt; gt;
gt; gt; quot;Jon Peltierquot; wrote:
gt; gt;
gt; gt;gt; Since the approach on my example uses additional ranges, you could set up
gt; gt;gt; ranges with formulas outside the pivot table, and make a regular chart
gt; gt;gt; using
gt; gt;gt; these ranges. I rarely use pivot charts, preferring regular charts for
gt; gt;gt; their
gt; gt;gt; greater flexibility.
gt; gt;gt;
gt; gt;gt; - Jon
gt; gt;gt; -------
gt; gt;gt; Jon Peltier, Microsoft Excel MVP
gt; gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; gt;gt; PeltierTech.com/
gt; gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; gt;gt; _______
gt; gt;gt;
gt; gt;gt; quot;layquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; question is, reformatting it after refreshing the table aside, is it
gt; gt;gt; gt; possible
gt; gt;gt; gt; to have some sort of conditional formatting applied to the quot;originalquot;
gt; gt;gt; gt; pivot
gt; gt;gt; gt; chart so that if say, my value goes down below a certain number, the
gt; gt;gt; gt; marker
gt; gt;gt; gt; for the pivot chart changes to a different color??
gt; gt;gt; gt;
gt; gt;gt; gt; like the example from your website that was applied to regular charts.
gt; gt;gt; gt; peltiertech.com/Excel/Charts/...nalChart1.html
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Jon Peltierquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt; Pivot charts are a real bummer with formatting. Any change to the
gt; gt;gt; gt;gt; underlying
gt; gt;gt; gt;gt; table resets the formatting. Microsoft admits that it's a problem, and
gt; gt;gt; gt;gt; the
gt; gt;gt; gt;gt; problem persists from Excel 2000 through 2003:
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Changing a PivotChart Removes Series Formatting (215904)
gt; gt;gt; gt;gt; support.microsoft.com/default...;EN-US;Q215904
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; - Jon
gt; gt;gt; gt;gt; -------
gt; gt;gt; gt;gt; Jon Peltier, Microsoft Excel MVP
gt; gt;gt; gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; gt;gt; gt;gt; PeltierTech.com/
gt; gt;gt; gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; gt;gt; gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; gt;gt; gt;gt; _______
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;layquot; gt; wrote in message
gt; gt;gt; gt;gt; news
gt; gt;gt; gt;gt; gt;I saw a similar question that asked about applying conditional
gt; gt;gt; gt;gt; gt;formatting
gt; gt;gt; gt;gt; gt;to
gt; gt;gt; gt;gt; gt; a chart, and i tried applying that quot;techniquequot; to a pivot chart, but
gt; gt;gt; gt;gt; gt; it
gt; gt;gt; gt;gt; gt; didn't return the same results.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Does anyone know if it's possible to actually apply the conditional
gt; gt;gt; gt;gt; gt; formatting to a pivot chart?
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Thanks!
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

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
PeltierTech.com/
_______

quot;layquot; gt; wrote in message
...
gt; ok, i tried using your suggestion and applied the quot;conditionalquot; ranges
gt; outside of my pivot table, but i can't get it to paste on my pivot chart!
gt; I'll click on quot;paste specialquot; but then, nothing. Grrrrrrr!!! we should all
gt; just revert back to the good ol fashion pen and paper!!!
gt;
gt; Thank you so much for all your help, jon!
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt; Well, you could revert to a VBA approach to color the points according to
gt;gt; your criteria. Or you could make the columns my approach uses large
gt;gt; enough
gt;gt; to accommodate the largest pivot table you would ever get, and use
gt;gt; dynamic
gt;gt; ranges to define the size of the series in the chart.
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt;gt; PeltierTech.com/
gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt;gt; _______
gt;gt;
gt;gt; quot;layquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; The thing is, i'm importing my data from a database in access so that
gt;gt; gt; any
gt;gt; gt; changes made in access would be reflected in the charts in excel. And i
gt;gt; gt; think
gt;gt; gt; pivot tables are the only one that will allow that.
gt;gt; gt;
gt;gt; gt; quot;Jon Peltierquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Since the approach on my example uses additional ranges, you could set
gt;gt; gt;gt; up
gt;gt; gt;gt; ranges with formulas outside the pivot table, and make a regular chart
gt;gt; gt;gt; using
gt;gt; gt;gt; these ranges. I rarely use pivot charts, preferring regular charts for
gt;gt; gt;gt; their
gt;gt; gt;gt; greater flexibility.
gt;gt; gt;gt;
gt;gt; gt;gt; - Jon
gt;gt; gt;gt; -------
gt;gt; gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt;gt; gt;gt; PeltierTech.com/
gt;gt; gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt;gt; gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt;gt; gt;gt; _______
gt;gt; gt;gt;
gt;gt; gt;gt; quot;layquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; question is, reformatting it after refreshing the table aside, is it
gt;gt; gt;gt; gt; possible
gt;gt; gt;gt; gt; to have some sort of conditional formatting applied to the
gt;gt; gt;gt; gt; quot;originalquot;
gt;gt; gt;gt; gt; pivot
gt;gt; gt;gt; gt; chart so that if say, my value goes down below a certain number, the
gt;gt; gt;gt; gt; marker
gt;gt; gt;gt; gt; for the pivot chart changes to a different color??
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; like the example from your website that was applied to regular
gt;gt; gt;gt; gt; charts.
gt;gt; gt;gt; gt; peltiertech.com/Excel/Charts/...nalChart1.html
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; quot;Jon Peltierquot; wrote:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; Pivot charts are a real bummer with formatting. Any change to the
gt;gt; gt;gt; gt;gt; underlying
gt;gt; gt;gt; gt;gt; table resets the formatting. Microsoft admits that it's a problem,
gt;gt; gt;gt; gt;gt; and
gt;gt; gt;gt; gt;gt; the
gt;gt; gt;gt; gt;gt; problem persists from Excel 2000 through 2003:
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Changing a PivotChart Removes Series Formatting (215904)
gt;gt; gt;gt; gt;gt; support.microsoft.com/default...;EN-US;Q215904
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; - Jon
gt;gt; gt;gt; gt;gt; -------
gt;gt; gt;gt; gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; gt;gt; gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt;gt; gt;gt; gt;gt; PeltierTech.com/
gt;gt; gt;gt; gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt;gt; gt;gt; gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt;gt; gt;gt; gt;gt; _______
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; quot;layquot; gt; wrote in message
gt;gt; gt;gt; gt;gt; news
gt;gt; gt;gt; gt;gt; gt;I saw a similar question that asked about applying conditional
gt;gt; gt;gt; gt;gt; gt;formatting
gt;gt; gt;gt; gt;gt; gt;to
gt;gt; gt;gt; gt;gt; gt; a chart, and i tried applying that quot;techniquequot; to a pivot chart,
gt;gt; gt;gt; gt;gt; gt; but
gt;gt; gt;gt; gt;gt; gt; it
gt;gt; gt;gt; gt;gt; gt; didn't return the same results.
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; Does anyone know if it's possible to actually apply the
gt;gt; gt;gt; gt;gt; gt; conditional
gt;gt; gt;gt; gt;gt; gt; formatting to a pivot chart?
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; Thanks!
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;