+ Reply to Thread
Results 1 to 3 of 3

How to select data series to format? (alternative needed)

  1. #1
    joeu2004@hotmail.com
    Guest

    How to select data series to format? (alternative needed)

    Is there an alternate way to select a data series to format
    in an XY Scatter chart?

    The only way I know of is to move the cursor close to the
    series line and right-click.

    But if the chart includes many data series and the lines
    are close together, it is difficult, if not "impossible", to
    select the desired line.

    I am looking for a method that presents me with a list
    of all the data series, and I select the one I want to
    "right click" (i.e. open the menu that include format,
    add trendline and clear, among others).

    Or something else that would not be so difficult to use.

  2. #2
    Andy Pope
    Guest

    Re: How to select data series to format? (alternative needed)

    Hi,

    You can use the cursor keys to cycle through the chart elements. More
    explanation can be found here.
    http://www.andypope.info/tips/tip003.htm

    One you have the correct element selected use CTRL+1 to display the
    format dialog. Or use the Format menu.

    The chart toolbar include a dropdown list of chart elements which will
    select the choosen item. To display the chart toolbar either right-click
    a toolbar to display a popup of available toolbars or use the menu View
    > Toolbars > Chart


    Cheers
    Andy

    joeu2004@hotmail.com wrote:
    > Is there an alternate way to select a data series to format
    > in an XY Scatter chart?
    >
    > The only way I know of is to move the cursor close to the
    > series line and right-click.
    >
    > But if the chart includes many data series and the lines
    > are close together, it is difficult, if not "impossible", to
    > select the desired line.
    >
    > I am looking for a method that presents me with a list
    > of all the data series, and I select the one I want to
    > "right click" (i.e. open the menu that include format,
    > add trendline and clear, among others).
    >
    > Or something else that would not be so difficult to use.


    --

    Andy Pope, Microsoft MVP - Excel
    http://www.andypope.info

  3. #3
    joeu2004@hotmail.com
    Guest

    Re: How to select data series to format? (alternative needed)

    "Andy Pope" wrote:
    > You can use the cursor keys to cycle through the chart
    > elements. More explanation can be found here.
    > http://www.andypope.info/tips/tip003.htm
    > One you have the correct element selected use CTRL+1
    > to display the format dialog. Or use the Format menu.


    Terrific! Thanks much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1