+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Make series formatting consistent between charts

  1. #1
    Registered User
    Join Date

    Make series formatting consistent between charts

    For each grade level in my school, I have a single table on which I track student test scores . I have several different line charts that pull different aspects of this data from this table. Each student is a series on these charts. How can I (somewhat easily) format the series so that each student's line color and style is consistent from one chart to the next? There are just too many students and charts to do this manually. If it helps, the students are in the same order on the charts, since it is all in a single table.

  2. #2
    Valued Forum Contributor quekbc's Avatar
    Join Date
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016

    Re: Make series formatting consistent between charts

    Hi Phil,

    Try this,
    Copy the chart that has the formatting you want to use on all other charts,

    select another chart, Paste Special, this is done differently depending on your version of Excel, but pressing, Alt E S should bring up the paste special window. Select Formats, click OK. That should do the trick.


+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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