+ Reply to Thread
Results 1 to 2 of 2

Automatic color change in graph depending on reference cell color

  1. #1
    Registered User
    Join Date
    09-14-2018
    Location
    Denmark
    MS-Off Ver
    Office 365
    Posts
    1

    Automatic color change in graph depending on reference cell color

    I have created a sales overview chart.
    Each customer is listed in row A
    Sales status year to date in row B
    Sales status last year in row C
    Deviation % in row D (row B vs row C) (color formated depending if < or > than 0)
    % share of total sales in row E
    Ranking in row F

    The graps show ranked share of sales in %
    Deviation % is shown to the right by each line in the graph.
    I would like to show by color if the customer is behind or ahead of last year so the color of each line changes depending if the cell in row D is <0% or >0% (deviation %)

    Screenprint attached.

    Can this be done?

    Thanks in advance!

    Michael
    Attached Images Attached Images

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016
    Posts
    5,833

    Re: Automatic color change in graph depending on reference cell color

    This is *THE* reference for Excel Charting: http://www.peltiertech.com/Excel/Charts/.

    This will probably involve splitting the basic data into different series and apply a color to each series. The author has an example.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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