Thank you, Steve, that sounds good, will try it when I get back to my machine.
Best regards,
Roger Belling
--- In ExcelVBA@yahoogroups.com, "noskosteve" <noskosteve@...> wrote:
>
>
> In 2007, this is:
>
> - Left Click any data series in the chart.
> - New TOP menu appears: Chart Tools
> - In DATA click on "Select Data".
> - In the "Legend Entry (Series) select the series you want to change.
> - Do a Move UP or Move Down using th esmall almost invisible arrow buttons above tht box.
>
> Steve
>
> --- 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