Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Format painting bars in a chart
I have a funky problem..not sure why. Let's say I create a bar chart, and
format each of the bars with a nice set of gradient colors, that varies based upon the data series source. In other words, several different color bars, on standard color per series. Now, if I happen to "touch" the data behind the chart in any way (in my case, a pivot table), the data element I change seems to go back to a "default" color scheme. I still have other bars that look like I want, but say, one month bar, for one data series, now looks different than the other 11 for the year. I want to to to "paint" the format from the good bars, back onto the mucked up bar. Any way you can think of to make this work? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Format painting bars in a chart
Pivot charts are well known for resetting their formatting when the pivot
table is adjusted. It's a known issue, and Microsoft recommends recording a macro when you reformat the chart, so you can rerun the macro as required. Alternatively you could create a custom chart type and reapply it as needed: http://peltiertech.com/Excel/ChartsH...stomTypes.html or make a regular chart from a pivot chart: http://pubs.logicalexpressions.com/P...cle.asp?ID=553 Also, I'd dispense with the fancy formatting, but I'm a voice in the marketing wilderness. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "PatK" wrote in message ... I have a funky problem..not sure why. Let's say I create a bar chart, and format each of the bars with a nice set of gradient colors, that varies based upon the data series source. In other words, several different color bars, on standard color per series. Now, if I happen to "touch" the data behind the chart in any way (in my case, a pivot table), the data element I change seems to go back to a "default" color scheme. I still have other bars that look like I want, but say, one month bar, for one data series, now looks different than the other 11 for the year. I want to to to "paint" the format from the good bars, back onto the mucked up bar. Any way you can think of to make this work? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Format painting bars in a chart
Thanks, Jon...I will give it a shot. I must say, I am finding more
"oddities" and bugs with the 2007 suite, than I had hoped. Oh well...I guess there is no looking back.... "Jon Peltier" wrote: Pivot charts are well known for resetting their formatting when the pivot table is adjusted. It's a known issue, and Microsoft recommends recording a macro when you reformat the chart, so you can rerun the macro as required. Alternatively you could create a custom chart type and reapply it as needed: http://peltiertech.com/Excel/ChartsH...stomTypes.html or make a regular chart from a pivot chart: http://pubs.logicalexpressions.com/P...cle.asp?ID=553 Also, I'd dispense with the fancy formatting, but I'm a voice in the marketing wilderness. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "PatK" wrote in message ... I have a funky problem..not sure why. Let's say I create a bar chart, and format each of the bars with a nice set of gradient colors, that varies based upon the data series source. In other words, several different color bars, on standard color per series. Now, if I happen to "touch" the data behind the chart in any way (in my case, a pivot table), the data element I change seems to go back to a "default" color scheme. I still have other bars that look like I want, but say, one month bar, for one data series, now looks different than the other 11 for the year. I want to to to "paint" the format from the good bars, back onto the mucked up bar. Any way you can think of to make this work? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Format painting bars in a chart
The only real use I have for 2007 is to answer questions, both here and for
my clients. I still do my development in 2000-2003, and for my own use I stick to 2003. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "PatK" wrote in message ... Thanks, Jon...I will give it a shot. I must say, I am finding more "oddities" and bugs with the 2007 suite, than I had hoped. Oh well...I guess there is no looking back.... "Jon Peltier" wrote: Pivot charts are well known for resetting their formatting when the pivot table is adjusted. It's a known issue, and Microsoft recommends recording a macro when you reformat the chart, so you can rerun the macro as required. Alternatively you could create a custom chart type and reapply it as needed: http://peltiertech.com/Excel/ChartsH...stomTypes.html or make a regular chart from a pivot chart: http://pubs.logicalexpressions.com/P...cle.asp?ID=553 Also, I'd dispense with the fancy formatting, but I'm a voice in the marketing wilderness. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "PatK" wrote in message ... I have a funky problem..not sure why. Let's say I create a bar chart, and format each of the bars with a nice set of gradient colors, that varies based upon the data series source. In other words, several different color bars, on standard color per series. Now, if I happen to "touch" the data behind the chart in any way (in my case, a pivot table), the data element I change seems to go back to a "default" color scheme. I still have other bars that look like I want, but say, one month bar, for one data series, now looks different than the other 11 for the year. I want to to to "paint" the format from the good bars, back onto the mucked up bar. Any way you can think of to make this work? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Painting Cells | Excel Discussion (Misc queries) | |||
Help with bars in bar chart | Charts and Charting in Excel | |||
Format Chart Bars with code? | Charts and Charting in Excel | |||
Painting Locked Cells | Excel Discussion (Misc queries) | |||
cell painting | Excel Worksheet Functions |