this is object model portion I use to set the background/interior of my pivot chart to RED. Also, if I remember correctly, I read somewhere that MS turned off the macro recorder functionality for either charts or pivot charts in 2007. Apparently they didn't have time to work on it.
With Selection.Interior
.ColorIndex = 3
.PatternColorIndex = 1
.Pattern = xlSolid
End With
It's simple to list what I did: click 'Record Macro'; right-click the mouse to pick 'Format Chart Area'; in Fill, select 'Gradient fill'; then pick the color I like; then Stop Recording (the macro); then check the module, there is nothing but '...ActiveChart Selected...'.
Thanks.
Msg for Ernest:
The process that I set up is not quite straightforward.
To cut a long story short, I need to calculate some market shares of products using Pivottables, taking advantage of '% Of Row' feature of PT. But if I only want to show some of the products, not all of them, '% Of Row' will give me the wrong calculation because it needs all the products presented in the PT to get the right percentage. So I have to cut&paste what I need from a complete PT to somewhere else, then create a chart based on the pasted data. So the chart will be regular chart, not a PT chart. Sometimes, I have to combine pieces of data from multiple PT because users want to see the products from different markets in the same chart.
Of course, your tip is certainly helpful for a start. I thank you for that.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.