+ Reply to Thread
Results 1 to 3 of 3

Multiple graph selection and editing

  1. #1
    Registered User
    Join Date
    12-09-2007
    Location
    Hungary, Törökbálint
    Posts
    16

    Multiple graph selection and editing

    Hi,
    I have an XY scatter diagram with 25 graphs.
    One serie of X, and 25 series of Y.
    The points of one series are linked by curved lines.
    There are 25 series, 25 curves.
    I want to edit the color of the curves in one step.
    How to select all curves and set the color of them to black?
    Or:
    How to select all curves and set the thickness of them to the same thickness in one step?
    The problem is the multiple selection of the curves.
    SHIFT+ click the next curve does not work.
    Any idea?
    Thanks.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Multiple graph selection and editing

    1) AFAIK no direct route.
    2) If you want to do it for one chart:
    a) change one of properties of one of series (say - line color)
    b) select next series
    c) press Ctrl+Y
    d) until all series series were changed goto b)
    e) change another property (say thickness)
    f) until last property has been changed goto b)
    3) if you want to apply the same formatting to next graph - save formatting of this first in templates.(graph tools-> project-> save as template)
    then select new chart and apply new template (graph tools -> project->change graph layout->templates-your template)

    Step 2 can be done with a macro (you register changes made to one series and then add a loop to cover all series)
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    12-09-2007
    Location
    Hungary, Törökbálint
    Posts
    16

    Re: Multiple graph selection and editing

    Hello Kaper,
    Very good idea. Thank you. This problem may be regarded as almost solved. Fine!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple graph selection and editing
    By veracity in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-25-2015, 02:09 PM
  2. Editing Graph Data Help
    By TKeefe in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-21-2015, 06:10 PM
  3. Help editing legend in graph
    By floricita in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-31-2014, 03:55 AM
  4. Cell selection without Editing
    By mido609 in forum Excel General
    Replies: 2
    Last Post: 01-01-2014, 03:14 AM
  5. [SOLVED] Bar graph editing help
    By m_buskirk in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-30-2012, 12:06 PM

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