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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 Quote:
|
Reply |
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 |