+ Reply to Thread
Results 1 to 2 of 2

chart change data series color

  1. 02-21-2011, 01:26 PM #1
    dpatel
    dpatel is offline
    Registered User
    Join Date
    07-01-2010
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    50

    chart change data series color

    Hello,

    I have always found really good solution & tips from this forum. Hope someone will able to help me to achive this one! I have got Pivot table with stacked bar chart. How can i change the data series color using for each loop functionality?
    File attached

    Thanks,
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-22-2011, 06:32 AM #2
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: chart change data series color 

    Please Login or Register  to view this content.
    Right click sheet tab, View Code , paste above.

    You give no detail about how or why the columns should be formatted so this code s imply applies an incremental value.
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1