Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
liontrader
 
Posts: n/a
Default change the color of points in 3D surface chart using VBA

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   Report Post  
John Mansfield
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change the color of all series in an excel chart in one go. Marielle Charts and Charting in Excel 2 May 3rd 23 07:45 PM
change font color of first cell in data table attached to chart momo Charts and Charting in Excel 2 February 18th 05 01:47 AM
Chart DataSource Change jj Charts and Charting in Excel 3 January 20th 05 01:12 AM
How to change the color of all series in an excel chart in one go. Mz2 Charts and Charting in Excel 1 January 20th 05 01:07 AM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 09:39 PM


All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"