xy scatter format
 

Hi
Hope someone can help. I have a chart i want to make look a little more professional.
The chart plots three points within two boxes. the points should be inside the box
box 1 has the following coordinates
x y
15 70000
15 115000
21.5 155800
30 155800
30 115000
25 70000
15 70000
the chart scale is x 14-32 & y 60000-160000
I would like to make the plot area outside the box black to indicate the no go area.
Is this possible?
Then to take it further there should be a further smaller box (coordinates unimportant) inside the 1st box to indicate a warning. I would like the plot area outside the 2nd box but inside the 1st box grey.
Is this also possible?
I know i could fomat the plot area with a picture to work as a background to do this for me but to be honest I don't know how to make the picture accurate to the scale I am working at.

Any suggestions would be most welcome.

cheers
nobby

xy scatter format
 

This is one application of the stacked area chart - time scale axis
approach described in my article:

http://pubs.logicalexpressions.com/P...cle.asp?ID=508

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


nobbyknownowt wrote:
Hi
Hope someone can help. I have a chart i want to make look a little more
professional.
The chart plots three points within two boxes. the points should be
inside the box
box 1 has the following coordinates
x y
15 70000
15 115000
21.5 155800
30 155800
30 115000
25 70000
15 70000
the chart scale is x 14-32 & y 60000-160000
I would like to make the plot area outside the box black to indicate
the no go area.
Is this possible?
Then to take it further there should be a further smaller box
(coordinates unimportant) inside the 1st box to indicate a warning. I
would like the plot area outside the 2nd box but inside the 1st box
grey.
Is this also possible?
I know i could fomat the plot area with a picture to work as a
background to do this for me but to be honest I don't know how to make
the picture accurate to the scale I am working at.

Any suggestions would be most welcome.

cheers
nobby

Thanks for the reply but now I'm really stumped. Afraid I cannot see where your coming from? Surely if I change my xy scatter chart to a stacked area with a time axis then I cannot use my original xy chart and data with my own axis? The outside of the chart is just really somewhere I want to format as it is outside the available ranges, the xy points in the middle are the important bits.
Maybe I'm missing the point totally here. Sorry if I sound dumb!
cheers
nobby