+ Reply to Thread
Results 1 to 2 of 2

series formatting across multiple charts

  1. #1
    Registered User
    Join Date
    07-24-2007
    Posts
    2

    series formatting across multiple charts

    I have several charts that pull different sorts of data from the same table. The charts all have the same series names (and these are in the same order, since they all pull from the same chart). I want each series (a person's name) to have the same formatting on all of the charts, so the data are easier to evaluate. Currently, Excel seems to be randomly assigning line color, marker style, etc.

    Short of manually formatting each series on each chart (huge job), how can I make any given series look the same on all of the charts?

  2. #2
    Registered User
    Join Date
    09-22-2011
    Location
    Washington, USA
    MS-Off Ver
    Excel 2003,2007, 2010
    Posts
    85

    Re: series formatting across multiple charts

    Copy the graph, then edit the source data. Everything should be identical.

+ 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