+ Reply to Thread
Results 1 to 5 of 5

Fix custom formatting of chart

  1. #1
    Registered User
    Join Date
    01-11-2021
    Location
    Canada
    MS-Off Ver
    MS Office 2016
    Posts
    77

    Fix custom formatting of chart

    Hi everyone!

    I would like to save the custom colors/shapes and text styles that I've made in the charts (I unfortunately lost them as I was looking for other types of charts and changed the referenced columns datas :S, guess you learn from experience :P ). Is there a way to protect or save the custom designs???

    Thanks in advance for your feedback!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Fix custom formatting of chart

    Try saving the chart as a chart template.

    Right click the chart and you should see the 'Save As Template' option.
    https://support.microsoft.com/en-us/...6-9f5e55187f2a
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-11-2021
    Location
    Canada
    MS-Off Ver
    MS Office 2016
    Posts
    77

    Re: Fix custom formatting of chart

    Hi Andy!

    As I was doing some research, I did found and now use the option you mention . Is it the optimal way of doing charts, experiencing different ways and time will tell me .Thanks for taking the time to let me know !

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Fix custom formatting of chart

    Only other ways are by coding all the formatting
    or you may be able to use copy + pastespecial but I expect this is limited.

  5. #5
    Registered User
    Join Date
    01-11-2021
    Location
    Canada
    MS-Off Ver
    MS Office 2016
    Posts
    77

    Re: Fix custom formatting of chart

    The saving template method seems like a good backup for now. Still have other things to rearrange. Thanks again for helping me out!

+ 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. Custom chart label for dynamic chart
    By cswshaun in forum Excel General
    Replies: 1
    Last Post: 07-08-2020, 02:47 AM
  2. Custom formatting issue using conditional formatting
    By wrongway15 in forum Excel General
    Replies: 2
    Last Post: 07-13-2014, 03:18 PM
  3. [SOLVED] Formatting Numarical Values with Custom Formatting
    By excelneub in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 07-11-2014, 04:06 PM
  4. Custom formatting chart axis
    By ABSTRAKTUS in forum Excel General
    Replies: 3
    Last Post: 05-30-2010, 01:13 AM
  5. Custom Data Label and Formatting in Chart
    By aderougemont in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-24-2008, 05:08 AM
  6. Custom Data Label and Formatting in Chart
    By aderougemont in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2008, 10:56 AM
  7. Replies: 1
    Last Post: 03-10-2006, 11:30 AM

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