Recreate the settings (gradient stops, RGB color etc.) for gradient pie chart fill

Dear Experts:

For some specific reason, I would like to be able to recreate the gradient pie chart fills that are created when one applies the built-in chart style 'Style 29' to a pie chart ...
... ie. I need to know the specific settings for these green gradient fills such as
    - number of gradient stops
    - RGB of the gradient fills
    - Bevel settings
    - etc.

Help is much appreciated. Thank you very much in advance.

I have attached a sample file for your convenience.


Regards, Andreas

  PieChart-Built-In-Style-29.xlsx
Andreas HermleTeam leaderAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
SteveConnect With a Mentor Commented:
OK, if you add the following code to your workbook:

Dim myChart As ChartObject

Set myChart = ActiveSheet.ChartObjects("mychart01")

Open in new window


Then set a watch on myChart if you step through the lines of code and then look in the watch window you can see all the asociated settings for the chart.

The use of etc. in your question means it is difficult to give a more specific answer as you could want almost any of the individual settings (of which there area  few)
0
 
Andreas HermleTeam leaderAuthor Commented:
Hi Barman,

thank you very much for your swift support, but I am afraid to tell you that I am not quite sure how to proceed.

I inserted a module, inserted that code and let it run. Now my only chart on the active worksheet is named myChart.

I also selected 'View-Watch Window' to show the 'Watch Window', but now, what do I have to do? Would be great if you could give me some more instructions steps.

Thank you very much in advance.

Regards, Andreas
0
 
SteveCommented:
If you step through the macro (which really does nothing to anything) you can allow the code to Set the object up... then using the watch on the myChart object you can view the properties (only if you step through using F8 and stop in the code) the properties will be viewable in the watch window.
0
 
Andreas HermleTeam leaderAuthor Commented:
Hi Barman,

ok, thank you very much. I will give it a try and let you know. Again, thank you very much.

Regards, Andreas
0
 
Andreas HermleTeam leaderAuthor Commented:
Hi Barman,

thank you very much for your swift and professional support. I really appreciate it.

Regards, Andreas
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.