+ Reply to Thread
Results 1 to 2 of 2

Multiple Chart Format

  1. #1
    Registered User
    Join Date
    07-03-2012
    Location
    md
    MS-Off Ver
    Excel 2010
    Posts
    37

    Multiple Chart Format

    Hello all,
    I have about 40 charts where I need to fix Y-Axis to reflect same range (0-500 for example) and fix certain other formatting on X-axis.

    I format one chart to suit my requirements and then using paste special format feature in Excel 2016 to fix chart number 2, number 3, ... up to chart number 40.

    When I select multiple charts at once, the paste special format option is not available. (meaning paste special format function works only when one chart is selected)

    I was wondering if this manual process could be more efficient as it is a tedious and time consuming process.

    Any pointers in this regard will be greatly appreciated.

    TIA
    Sam

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Multiple Chart Format

    Hi

    this macro should copy the active (selected) chart and apply its formatting to each chart in the active worksheet

    Please Login or Register  to view this content.
    Last edited by NickyC; 05-17-2017 at 09:54 PM. Reason: clarification

+ 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. Line Chart Multiple Data Series Format Same Color
    By mark.dehoog in forum Excel General
    Replies: 8
    Last Post: 02-16-2015, 05:15 AM
  2. River Cross Section Chart - Area Chart Multiple series
    By ppdominic in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-15-2014, 06:01 AM
  3. [SOLVED] Chart Data Labels and Format Codes - Multiple Criteria
    By hoffey in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-21-2013, 11:15 AM
  4. Replies: 3
    Last Post: 10-09-2012, 09:34 PM
  5. Format date format in chart title
    By welchs101 in forum Excel General
    Replies: 5
    Last Post: 07-05-2011, 10:59 AM
  6. Conditional Format - Format Transfer To Chart
    By ju1eshart in forum Excel General
    Replies: 0
    Last Post: 06-01-2006, 09:50 AM
  7. [SOLVED] need to format chart columns based on info not displayed in chart
    By papa jonah in forum Excel General
    Replies: 0
    Last Post: 03-21-2005, 05: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