Closed Thread
Results 1 to 2 of 2

coloring bars in a stacked bar chart (Yamazumi chart) on basis of text

  1. #1
    Registered User
    Join Date
    05-26-2014
    Posts
    5

    Question coloring bars in a stacked bar chart (Yamazumi chart) on basis of text

    Hallo,

    I'm Rob and I'm doing a project for school.
    For this project I'm using a Yamazumi chart (that I found) for balancing the workload between workstations.
    I've found a template that does that, but I would like to color the bars (red for waste, green for value adding activities and orange for necessary non value adding activities).
    The bars series name starts with Waste, VA or NVA. Is it possible to color the bars on basis on the text or is there an other way?


    ps: I saw this link, but I didn't fully understand it
    http://www.excelforum.com/excel-programming-vba-Attachment 320737macros/713028-stacked-area-chart-series-colour-change.htmlYamazumi chart.xlsm

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: coloring bars in a stacked bar chart (Yamazumi chart) on basis of text

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 05-26-2014, 05:11 AM
  2. 3 Separate Stacked bars in 1 Chart
    By bglick in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-18-2013, 11:20 AM
  3. Help hiding zero value bars in stacked 3d bar chart
    By tuna666 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-17-2013, 07:12 AM
  4. How to chart 2 stacked bars per day?
    By Ingeniero1 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 02-24-2009, 11:59 AM
  5. To create a stacked column chart and group the stacked bars togeth
    By Jacqueline in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-18-2005, 10:06 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