Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: data markers in xy scatter charts

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How can I do the following to data in a scatter chart?

    For a given set of plotted coordinates (x,y) I want to associate another value that will then plot to scale as the data marker in the scatter chart.

    For example, if coordinates (x1, y1) represent a project of size A, and coordinates (x2, y2) represent a project of size twice as large as A, the data marker for the second project will be depicted as twice as large as that the first on the scatter chart.

    Also, as a variation of the same principle, how do I bracket the sizes of the data markers? For example, if I want the data markers for projects between size 0 and 2xA to be depicted with one size and those for projects between 2xA and 4xA with another size, and those between 4xA and 10xA with a third size, how can I do that?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sounds like a bubble chart. Have you considered this chart type? Suppose A1:B4 contains {"X","Y";1,2;3,4;4,3}. You could enter the formula, =B2/MAX(B:B) or =B2/MIN(B:B), into C2 and fill down to C4. Next, select A1:C4, choose the Bubble Chart type from the Chart Wizard, select "Series in columns" at Step 2 of 4, and press [ Finish ].

    [ This Message was edited by: Mark W. on 2002-02-25 11:28 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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