+ Reply to Thread
Results 1 to 5 of 5

Convert Existing Chart Colors to Defaults (Excel 2007)

  1. #1
    Registered User
    Join Date
    10-04-2010
    Location
    Corvallis, OR
    MS-Off Ver
    Excel 2007
    Posts
    3

    Question Convert Existing Chart Colors to Defaults (Excel 2007)

    Morning everyone,

    My office is looking to make the move from Excel 2003 to Excel 2007. However, we have reports coming from two different sources (with different colors). These off-colored reports would be converted automatically in 2003 when opened. Is there a way to mirror this functionality in Excel 2007? I'm open to virtually any suggestion, whether its Macro's or configuration.

    Thanks,

    Aardvark

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,474

    Re: Convert Existing Chart Colors to Defaults (Excel 2007)

    Hi Aardvark,
    Why not upgrade to 2010 Excel now that it's out?
    http://office.microsoft.com/en-us/ex...101806958.aspx

    After looking in Excel Options for an answer, and not finding one, I recorded a macro to change colors.
    The macro recorded code like:
    Please Login or Register  to view this content.
    I then went to the net and searched for "Excel VBA Theme"
    There are many hits you should read to see which one can solve your probelm.
    Try:
    http://www.databison.com/index.php/e...nge-using-vba/ or
    http://www.tech-archive.net/Archive/.../msg01515.html

  3. #3
    Registered User
    Join Date
    10-04-2010
    Location
    Corvallis, OR
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Convert Existing Chart Colors to Defaults (Excel 2007)

    Marvin,

    Thanks for getting back to me so quick, I'll have to explore those links and see if I can cook up something. I wish we could upgrade to 2010, however you know how office politics are. In fact, I'm not even a member of IT. I'm a member of the Software Engineering team who was asked to find a solution. If IT knew the chart colors were not converted seamlessly chances are we would be stuck with 2003!

    Let me look into it (and your solution) and i'll post back with what I find.

    Thanks again,

    Aardvark

  4. #4
    Registered User
    Join Date
    10-04-2010
    Location
    Corvallis, OR
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Convert Existing Chart Colors to Defaults (Excel 2007)

    Still no luck, the only way I have managed to switch the colors on existing charts was to save my chart as a template and apply it. However, I have a few different types of charts (bar, line, pie) and would need to do a template for each one. Am I overlooking something obvious? Is there an add-in or anything that could help me overcome this?

    Thanks again,

    Aardvark

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,474

    Re: Convert Existing Chart Colors to Defaults (Excel 2007)

    Hi Aardvark,

    I think that Microsoft rewrote the whole charting engine between 2003 and 2007 releases. A lot of things changed between those versions.

    I did find http://dearmicrosoftofficeteam.blogs...please_03.html but I'm not sure it helps your question.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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