Thank you, David.
I have Office Professional 2007 with all my Excel workbooks as .xls
files in 97/2003 compatibility mode for compatibility with other people,
under Vista Business w/o SP, and I cannot find any Series Order tab in
my Format Data Series box. (It would be parallel to Fill, Line Color,
Line Style etc., I suppose.) Is there some VBA phrasing that I could
try? I tend not to get tips when I want them, but always when they are
just distracting.
Best regards, Roger Belling
--- In ExcelVBA@yahoogroups.com, <david.smart@...> wrote:
>
> 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