Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
Scatter Chart Axis as text in C# Web appl | Charts and Charting in Excel | |||
why does currency format change to number format? | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions |