+ Reply to Thread
Results 1 to 2 of 2

dynamic graph coloring

  1. #1
    Registered User
    Join Date
    12-16-2015
    Location
    Italy
    MS-Off Ver
    2013
    Posts
    1

    dynamic graph coloring

    Hello,
    I need to make the graph coloring dynamic, e.g. red-Yellow-green. Any sample has a flag associated, and it can be -1, 0 or +1. These flags drive the coloring of the bar chart.
    Can anybody help?

    Thank you
    /Tommaso

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: dynamic graph coloring

    Making the color of a series dynamic is hard, and making the color of individual elements of a series different colors is even more difficult.

    So generally it's best to push your data into helper series, where each helper series is a different color, and all the logical choosing is in the push to the helpers.

    See attached for an example with a scatterplot.
    Attached Files Attached Files
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

+ 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. Graph alternate coloring
    By maximpinto in forum Excel General
    Replies: 3
    Last Post: 06-03-2014, 04:16 AM
  2. [SOLVED] Textbox dynamic coloring
    By Villalobos in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2014, 11:27 AM
  3. Dynamic Chart Not Changing (With Conditional Coloring)--Example Attached
    By jsgrunwald in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-25-2013, 11:57 AM
  4. Selcting a dynamic range of cells and coloring it
    By nynamyna in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2011, 01:58 PM
  5. Replies: 6
    Last Post: 01-25-2006, 02:45 PM
  6. [SOLVED] Dynamic pie chart coloring
    By David in forum Excel General
    Replies: 1
    Last Post: 09-11-2005, 12:05 AM
  7. [SOLVED] want to make a bubble graph with 20 bubbles and gradient coloring.
    By dstout in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-16-2005, 12:06 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