+ Reply to Thread
Results 1 to 3 of 3

Color a value in the plot area

  1. #1
    Registered User
    Join Date
    03-23-2016
    Location
    East Peoria Il
    MS-Off Ver
    2013
    Posts
    1

    Color a value in the plot area

    Is there a quick way without VB code to color the cell in the plot area? The area I am referring to is circled in blue on the attachment. Thanks for any suggestions
    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,436

    Re: Color a value in the plot area

    Formatting of data table is very limited.

    You might consider using worksheet cells to create a data table you can control.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Color a value in the plot area

    Very good idea. You can either go ahead and use the "Camera" and merge a table picture of the graph.

+ 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. How do i change the default plot area backgroung color in excel?
    By Jared in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-29-2015, 01:45 AM
  2. [SOLVED] Setting widths at the plot's left and right (inside the plot area)
    By simone77 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-07-2012, 08:32 AM
  3. Plot histogram with part of chart area color
    By ngkj in forum Excel General
    Replies: 0
    Last Post: 06-26-2012, 01:50 AM
  4. Excel 2004 mac plot area color not matching
    By bill22 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-12-2011, 01:06 AM
  5. Changing Plot Area color of Chart using VBA
    By tmac98 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2008, 11:47 PM
  6. color boxes are the plot area background
    By Barry Au in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-03-2007, 06:43 PM
  7. [SOLVED] How do I change the excel chart default plot area color?
    By gg96555 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-08-2005, 04:06 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