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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.aspx?scid=kb;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
_______
 
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/ConditionalChart1.html
 
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
_______
 
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.
 
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
_______
 
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!
 
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/
_______
 
Back
Top