Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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! |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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! |
#4
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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! |
#5
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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! |
#6
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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! |
#7
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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! |
#8
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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! |
#9
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Preserve formatting in Pivot Chart | Charts and Charting in Excel | |||
Location of pivot chart | Charts and Charting in Excel | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel |