Don't know what version of Excel you're using, but in 2003 it's not done
with a "bring to front".
In 2003, you bring up "Format Data Series", e.g. by right clicking on
one of the data series in the chart.
Then go to the tab "Series Order" and move your obscured series down to
bring them to the front.
Regards, Dave S
________________________________
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
Behalf Of Roger
Sent: Thursday, 1 December 2011 13:24
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] "Bring to Front" a data series in a chart without
changing sort order in legend
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
----------
Visit our website at http://www.ubs.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.
UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.
[Non-text portions of this message have been removed]
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