+ Reply to Thread
Results 1 to 2 of 2

Is there a 'format painter' equivalent to use on many charts?

  1. #1
    Registered User
    Join Date
    09-03-2008
    Location
    Chicago, IL
    Posts
    1

    Is there a 'format painter' equivalent to use on many charts?

    I'm trying to format a group of charts (roughly 40) so that they all have the
    same formatting (font sizes, colors, alignment, etc.). Is there an easy way
    to do this without having to change every axis and background on every chart?


    I've tried the trick where you change something on one chart, click on
    another, and press F4, but it was formatting all text on the chart in the
    same way. I'm looking to have different fonts for the title, labels, and
    axis.

    Thanks!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430
    I see Jon gave you answer in the MS newgroups.

    Please do not post your question in multiple places without having the courtesy to warning them that other may also be answering the same question.
    Cheers
    Andy
    www.andypope.info

+ 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. Converting the Format of the Date
    By aki096 in forum Excel General
    Replies: 3
    Last Post: 05-29-2008, 01:02 PM
  2. Export chart format to VBA
    By danmak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2007, 05:41 AM
  3. automatically update charts
    By slimjen in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-04-2007, 06:25 PM
  4. Replies: 1
    Last Post: 07-14-2007, 03:52 AM
  5. cell format of numbers
    By joshtex in forum Excel General
    Replies: 3
    Last Post: 03-23-2007, 03:47 PM

Tags for this Thread

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