Results 1 to 2 of 2

Markers of graph (conditional charting)

Threaded View

Beginner Level Markers of graph (conditional... 02-28-2012, 04:05 AM
Steve=True Re: Markers of graph... 03-03-2012, 06:01 PM
  1. #1
    Registered User
    Join Date
    01-13-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    76

    Markers of graph (conditional charting)

    Hello everyone,

    I have a question on conditional charting.
    I am using scatter xy graph straight line with marker.
    Let me ask in this way: Now I have a few data. After plotting using scatter xy graph, I find the average, and I will be draw a horizontal straight line on the plot area.
    So is there anyway to customize my scatter xy graph so that it shows a different marker whenever the value is more than (average*2)?
    And is there a way to customize the marker so it also will show another different marker when there are 6 or more points in the graph is increasing/decreasing?
    p.s. my data is dynamic, and the graph fluctuate a lot.
    Last edited by Beginner Level; 02-28-2012 at 04:48 AM.

Thread Information

Users Browsing this Thread

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

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