Solved

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

Posted on 2013-01-31
5
406 Views
Last Modified: 2013-02-01
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
0
Comment
Question by:AndreasHermle
  • 3
  • 2
5 Comments
 
LVL 24

Accepted Solution

by:
Steve earned 500 total points
ID: 38839530
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
 

Author Comment

by:AndreasHermle
ID: 38839662
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
 
LVL 24

Expert Comment

by:Steve
ID: 38840048
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
 

Author Comment

by:AndreasHermle
ID: 38840989
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
 

Author Closing Comment

by:AndreasHermle
ID: 38842866
Hi Barman,

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

Regards, Andreas
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now