Solved

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

Posted on 2013-01-31
5
411 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

751 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