Thread: 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


--
nobbyknownowt

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


Jon Peltier Wrote:
> 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
>
>


--
nobbyknownowt