Solved

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

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

785 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