Results 1 to 3 of 3

Conditional format a data point in line chart

Threaded View

  1. #1
    Registered User
    Join Date
    04-19-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    11

    Conditional format a data point in line chart

    hihi. is it possible to format a data point in a line chart in excel?
    for example if i place an X next to data in Column B of the data range A1:C4 the chart is plotting, then the data point is red.

    Ie

    Apples 3
    Bananas 4 X
    kiwis 6
    plums 8 X


    ie The data points in the line chart will be red for bananas and plums

    hope that makes?!
    Last edited by grekis; 06-25-2020 at 02:58 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Plotting a line from a specified point on Y axis to a chart line
    By enanthate in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-12-2016, 09:00 AM
  2. Line Chart data point limits
    By randinator in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-13-2014, 11:17 AM
  3. conditional format data point in scatter plot
    By adam1630 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2011, 06:43 AM
  4. Replies: 2
    Last Post: 06-27-2011, 10:47 PM
  5. Macro to format data point and add label in chart
    By Scottmk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2010, 08:54 AM
  6. automate chart and format data point colors
    By Grateful in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-16-2009, 11:28 AM
  7. Replies: 2
    Last Post: 10-06-2007, 01:26 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