+ Reply to Thread
Results 1 to 3 of 3

Mark values on Bar chart

  1. #1
    Registered User
    Join Date
    06-04-2014
    Posts
    34

    Mark values on Bar chart

    Hi!
    I have a range of 30 colors in RGB from white (value 0) to Brown (value 30) and I would like to mark where on the scale a specific color value is, +- 1. Let's say my actual color value is 21, so I would like to mark 20 and 22. Like the attached picture (if there is any). How can I do that?

    Thanks!
    Attached Images Attached Images

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Mark values on Bar chart

    You can use a combination chart, bar and xy-scatter.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-04-2014
    Posts
    34

    Re: Mark values on Bar chart

    Looks perfect! Thanks!

+ 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. excel chart tick mark problem
    By jlj10 in forum Excel General
    Replies: 5
    Last Post: 08-16-2016, 04:52 AM
  2. [SOLVED] how to remove plus mark in the chart.
    By Sekars in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-05-2016, 12:25 PM
  3. Adding target mark to bar chart
    By martinbrader in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-03-2015, 03:25 AM
  4. Mark margins in line chart
    By JochenB in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-02-2013, 08:45 AM
  5. Replies: 2
    Last Post: 12-02-2012, 07:30 PM
  6. How to mark this chart
    By omer123456 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-18-2011, 04:12 PM
  7. How to mark a calendar (like a reservation chart)
    By jokula in forum Excel General
    Replies: 0
    Last Post: 01-14-2009, 01:47 PM

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