Excel Excel format legend color in chart

R

rgsbouma

Joined
Apr 26, 2012
Messages
1
Reaction score
0
In an Excel chart I would like to format the colors in the legend of a chart based on a range in the worksheet with static or conditionally formatted colors. Is this possible?
The range with the legend series always needs to have the same coloring.

Thanks in advance for helping me out,

Ron B.
 

Attachments

  • Colour Chart (VBA, Test).zip
    21.5 KB · Views: 121

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disappearing chart legend 2
Set Chart Legend in VBA 1
Changing/Manipulating Legend range for a Pivot Chart in XL2010 vsXL2003 and below. 0
Excel Excel chart and Data Table 0
Chart Colors and Legend 10
Odd Chart Format Results 1
PowerPoint Embed scroll excel chart and data in powerpoint 0
Excel-Legend 1

Top