Thread: 3D column chart
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 3D column chart

Consider whether a 3D column chart is a reasonable chart type for your data.
Or for any data. In general, 3D charts are worse at showing data accurately
and people are worse at reading them accurately. What kind of 2D charts also
can show this data?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"canbya" wrote in message
ups.com...
Hi:
The first series in a 3D column chart is a lot less than 1%. It shows
up as a gray blur on the floor even though the color of the series is
white. This happens because the 3d shading on top is gray.

Is there a way to address only the top rectangle of each bar column and
remove the shading within that series?

The only way I have been able to get around this so far is saving a
white bmp in Paint. Then I import the texture and apply it.
With ActiveChart.SeriesCollection(6)
.Fill.UserTextured TextureFile:= _
"C:\temp\white.bmp"
.Fill.Visible = True
End With