Solved

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

Posted on 2013-01-31
5
410 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

828 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