troubleshooting Question

MS Excel Plot Area Formatting

Avatar of AlFrancoFreeman
AlFrancoFreemanFlag for Ireland asked on
Lotus IBMMicrosoft Excel
2 Comments1 Solution316 ViewsLast Modified:

We want to represent data on a scatter graph with the plot area formatted with multiple(custom) quadrants. For example, the plot area in the range
x: -20% - 0
y: 0 - 5
should have one colour while another range, say,
x: -20% - 0
y: 5 - 10
should have another colour.
We should be able to change these ranges somehow (so using a jpeg as the background would not really work).
The attached (kinda) shows what I mean.
Hope this is clear!
Thanks a mil

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros