Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 ? |
#2
![]() |
|||
|
|||
![]()
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.Inte rior.ColorIndex = 6 ActiveChart.Legend.LegendEntries(2).LegendKey.Inte rior.ColorIndex = 3 ---- Regards, John Mansfield http://www.pdbook.com "liontrader" wrote: 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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
change font color of first cell in data table attached to chart | Charts and Charting in Excel | |||
Chart DataSource Change | Charts and Charting in Excel | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel |