Markers of graph (conditional charting)

**Beginner Level** · 02-28-2012, 04:05 AM

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.

**Steve=True** · 03-03-2012, 06:01 PM

Hello,

You may need to modify your formulas or create a new range for your graph.

In the new formulas, you will want to use the NA() function to plot 2 different chart series. You can then change the value of each chart series to the format you want.

Here is a tutorial that shows it in action for a column graph, but you can use the same concept for each XY Series.
http://www.exceldashboardtemplates.com/?p=1036

Here is a sample of what a conditional point may look like:
MarkersOutOfErrorRange.png

Is this what you are looking for?

Please let me know if this helps!

Thanks and Good luck!

Steve=True

Markers of graph (conditional charting)

LinkBack

Thread Tools

Rate This Thread

Display

Markers of graph (conditional charting)

Re: Markers of graph (conditional charting)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions