I use crosses as markers for regular data points, and colored squares
for high-accuracy recalculations of outliers. When the recalculation
has the same result as the original calculation, the square appears
centered over the cross, if the cross is big enough to show from under
the square. The picture would be even better, for a publication, if the
crosses showed on top of the squares. But the crosses as the normal
markers I still want to appear on top in the legend.
I imagine there is a way to do a "Bring to Front" on the regular data
series? My button is greyed out in Drawing Tools, and I cannot find a
handle in VBA either. My chart shows only under ActiveSheet.Shapes, and
I cannot find any command to do anything with it. (Besides I have a
Shape for pointing to one particular data point, grouped with the chart,
which may complicate matters somewhat.)
Thanks if you can help. Roger Belling
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar