+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    Registered User
    Join Date
    01-08-2012
    Location
    dallas
    MS-Off Ver
    Excel 2007
    Posts
    3

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

    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!!
    Attached Files Attached Files

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

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

    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.
    Attached Files Attached Files
    Last edited by teylyn; 01-09-2012 at 04:00 PM.

  3. #3
    Registered User
    Join Date
    01-08-2012
    Location
    dallas
    MS-Off Ver
    Excel 2007
    Posts
    3

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

    Great!
    That's working!
    Thank you

  4. #4
    Registered User
    Join Date
    01-08-2012
    Location
    dallas
    MS-Off Ver
    Excel 2007
    Posts
    3

    Wink Re: Plot points on a area chart or plot areas on a scatter chart

    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!
    Attached Files Attached Files

  5. #5
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

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

    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,
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1