Featured Product

making area of graph semi-transparent?

I have created a 3-d area chart in excel 2000 that contains 4 data series. Viewing the graph, some of the data is hidden by a data series in front. I need the data series in order, so changing series order will not work. I tried different orientations but some data is still hidden.

A solution would be to have the fill of one data series semi-transparent to allow viewing of the hidden series. Is there any way to do this in excel?

thanks

Posted by Mike on January 15, 2002 7:43 PM

I couldn't figure out any way to make the bars semitransparent but if you add this code to the Mouse_Down event it will let you toggle off the fill colors of the bars.

'-------------------------------Dim ElementID As LongDim d As LongDim e As Long

'Find out where the mouse was when the left button was pressedActiveChart.GetChartElement x, y, ElementID, d, e

'Make sure user clicked on one of the bars...If ElementID &LT;&GT; 3 Then Exit Sub

(9 responses) Hello all, I am new to the world of VBA and just started working on creating macros about 5 weeks ago. I have been watching YouTube videos a

Let's Connect

MrExcel.com debuted on November 21, 1998.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on this
web site are provided "as is" and we do not guarantee that they can be used in all
situations.
This site contains affiliate links. Any affiliate commissions that we
earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.com
running. You can earn a commission for sales leads that you send to us by joining our
affiliate program.
View my Privacy Policy and Terms of Use.