Hi guys,
I'm doing a scatter plot with two variables on both axis. What code would I need in order to highlight my graph? For example, if the value for my X axis goes above 5, I would like to highlight it red or if the Y value goes below 0 i would also like to highlight it red.
My plot is a live automatically updating chart so how could i possibly go about doing this?
Thanks,
Russ
Hi,
I think the easiest way is to create two data sets from your one, and plot them separately on the same chart. Please see the attachment.
Last edited by sweep; 08-04-2014 at 03:49 AM.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
1) there is no attachement, but I think idea is simple enough.
2) probably it will be necessary to use NA function for not_in_this_sereies_data
lets assume your Ys are in B column, so the red series Y's formula would go:
Formula:
Please Login or Register to view this content.
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks