Plot points on a area chart or plot areas on a scatter chart

**maggy** · 01-08-2012, 10:31 PM

Hi!

I'd like to plot some points like A(xa,ya) and B (xb, yb) on a area chart. I have defined and plotted 3 zones on the area chart and I would like to visually see in which zone my A and B are for example. see attached file

Do you know if this is possible to plot points on a area chart or plot areas on a scatter chart?

Thank you!!

**teylyn** · 01-09-2012, 03:33 AM

Hello,

Select H1:H6, copy, select the chart, use Paste Special and accept the defaults. Select the new data series and change the chart type to XY chart. Edit the new data series and select the ranges for X and Y values.

see attached.

**maggy** · 01-09-2012, 07:22 AM

Great!
That's working!
Thank you

**maggy** · 01-14-2012, 06:28 PM

Hi,

I'd like to be able to quickly plot projects name into a defined zone chart for selection - the desired chart is plotted on the page "data".
The zones are defined - see chart "zone to show" - my x axis has to be between 0 to 5 and y axis between 0 to 3. The axis are properly displayed on this chart.

After I need to add to projects defined by an (x,y) to the chart and I would like to display their names.
Each time I do that, my x axis is taking the scale 0 to 5 as a category axis. so the chart does not look nice as the 0 on x axis does not correspond to the 0 on the y axis like in the "zone to show" chart (white area around) - see chart "tentative for zone + data". Plus the points are not aligned to x axis so the project plot are not even correct.

Is there anyone who knows how to combine a area chart (chart "zone to show") with a scatter chart (chart " project name plot") without messing the x axis?

In addition, I would have to display many projects. Right now, I add manually one by one by creating a serie, selecting the name, then the x value and y value to display a point, after I need to add the data label and then select the series name to be displayed. If you have any idea about automating the chart (taking each project, plotting x,y into the zone chart and displaying the name) with a macro that could be really great!

I have tried many things but nothing works and this is driving me crazy! I need your help!!

Thank you for your time and explanations!

**teylyn** · 01-17-2012, 04:39 AM

Hello,

In your sample file, the data for zone 2 has values up to 4.8, but you limit the X axis to show a max value of 3. That's fine, if it suits your needs. If you define the maximum for the primary X axis, you can also define the same maximum for the secondary X axis.

Add the Project data points as an XY chart series on the secondary axis as described above. Then format both primary and secondary Y axes to have the same maximum

You can then use the free XY Chart Labeler add-in, available here http://www.appspro.com/Utilities/ChartLabeler.htm
Install it and then use it to add the text labels in column I to the chart.

See attached. The numbers are a bit unfortunate, since a lot of data is cut off with both Y axes set to a max of 3. Change the max to 6 for both axes and compare.

cheers,