Scatter plot : highlight multiple regions of the X axis

**Virgule** · 10-07-2011, 01:04 PM

Hello,

I am using excel 2010 and I am making a scatter plot of the elevation of a course. My scatter data is selected as follows :

Distance from start (X axis)-:--0---5---23---150---217--...
Elevation (Y axis)---------------:--3---3---10----28-----15--...

I want to do 2 things to add to the visual of the plot :

1 ) I want to highlight with a light colour a particular region of the X axis. Let's say from distance 23 to 150 the course goes under a tunnel. I want to highlight a band of all the Y range and X ranging from 23 to 150 and possibly add overlay text saying TUNNEL. It would be preferable if the highlighted region is tied to the corresponding cells and the text tied to the highlighted region.

2 ) I want to add text boxes pointing to particular points of the scatter data. Let's say the 217m mark is point C. I want a POINT C text box pointing to the corresponding point (ideally tied to it) with an arrow.

For the purpose, I've added these rows :

Punctual identification------:------------------------------C---...
Ranged identification--------:----------------TUNNEL------...
Distance from start (X axis)-:--0---5---23---150---217--...
Elevation (Y axis)---------------:--3---3---10----28----15--...

I've posted this thread on another forum and will update the other thread with the proper solution.
http://www.mrexcel.com/forum/showthread.php?t=584136

Thanks in advance.

**Andy Pope** · 10-08-2011, 07:51 AM

You can add 2 extra series plotted as stacked bar.

Other series can be used to create labels and leader lines.

**Virgule** · 10-12-2011, 11:35 AM

Thank you very much, Andy Pope.

You've been very helpful.

**parthiyer101** · 03-15-2012, 05:30 AM

Hello,

I am having the same problem as Virgule. So imagine Virgule's problem, but say I want to add another data series called Angle: 10, 15, 20, 23, 62. But this data should be on the secondary vertical axis and in the same X-Y scatter format as the elevation series, while keeping the solution to Virgule's problem unchanged. Can Excel 2010 do that, or do I have to resort to Macros or drawing shapes?

Thanks

**teylyn** · 03-15-2012, 05:52 AM

parthiyer101,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.