change the color of points in 3D surface chart using VBA

L

liontrader

I wanna change the color of single points in a 3d surface chart according to
a seperate value for each point (i.e. date, time, price chart with the
surface color representing the volume). I figured it out for 3d column charts
using the sereiesCollection(i).points method but found no solution for a
surface chart.
Any ideas ?
 
J

John Mansfield

Liontrader,

For the 3d surface chart, you have to go to the legend key to change the
colors. Try something like this:

ActiveChart.Legend.LegendEntries(1).LegendKey.Interior.ColorIndex = 6
ActiveChart.Legend.LegendEntries(2).LegendKey.Interior.ColorIndex = 3
 

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

Doughnut Chart linked with the slicer in the pivot table 0
multiple 3D equations in one excel surface chart 1
not able to get series value for 3d-surface chart 1
Possible to change colors 3d bar chart by point in Excel 2003? 2
Points Dimensions on a 3D Clustered Column Chart 4
how change the legend scale of surface chart in XL2007 2
How to select numeric 'series axis' in a surface chart? 4
Change background / color of chart worksheet? 3

Top