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!