Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Drawing shapes in a chart
I'm not sure how I would go about this. But I am creating Quadrant graphs.
They are scatter plots and the graph is divided into 4 sections (2 yellow, 1 green, and 1 red) I made the plot area yellow, but now I need to know if its possible to write a macro to draw Red and Green boxes on the graph and their size set by points on the graph? For instance, there is a median point so the red box would go from (0,0) in the lower left to (medianx,mediany) on the upper right. And the green box would have (medianx,mediany) on the lower left and the (axisxmax,axisymax) on the upper right. Is it possible to draw shapes with values from a graph? If so could someone fill me in on how to do it! Thanks - it would save soo much time!! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Drawing shapes in a chart
Hi,
Rather than draw shapes you can use extra data series plotted as different chart types. See here for explanation, http://peltiertech.com/Excel/Charts/...ackground.html Cheers Andy ChadTarget wrote: I'm not sure how I would go about this. But I am creating Quadrant graphs. They are scatter plots and the graph is divided into 4 sections (2 yellow, 1 green, and 1 red) I made the plot area yellow, but now I need to know if its possible to write a macro to draw Red and Green boxes on the graph and their size set by points on the graph? For instance, there is a median point so the red box would go from (0,0) in the lower left to (medianx,mediany) on the upper right. And the green box would have (medianx,mediany) on the lower left and the (axisxmax,axisymax) on the upper right. Is it possible to draw shapes with values from a graph? If so could someone fill me in on how to do it! Thanks - it would save soo much time!! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically moving a drawing object in a chart | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
= Drawing more lines in a OHLCV chart = | Charts and Charting in Excel |