Placing a box or shaded area on a variable chart

xenoborg4

New Member
Joined
Nov 20, 2005
Messages
3


The position of all the lines changes relative do the data in the workbook.
Using arrays, I can find the point where yellow = black.

So, I can find the cords of where I want a box and put them in cells. The question is how do I tell it to make a box on my chart.
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
I'm not clear about what you actually want here. Rather than the generic 'I can find the point where yellow = black' and 'I can find the cords of where I want a box and put them in cells', be precise - given the data, what, exactly, do you need - do you need, perhaps, to set a different background for the area between two curves?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,671
Messages
5,573,583
Members
412,537
Latest member
Mohamed_5966
Top