Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Custom graph (Excel xp)

    I need to make some graphs like the one i've attached. I don't know of a way in excel to do it or modify an existing one to do this. I need an x and y axis with squares which start at the zero point and are sized according to a value in the worksheet. thanks
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Custom graph (Excel xp)

    Have you looked at the bubble chart?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Custom graph (Excel xp)

    Try this to get you started. It is an XY Scatter.

    I added 50 horz and 50 vert lines to "fill" in the boxes. You might have to add some more lines to "fill" the squares if you want them truly solid. You might need even more to print and fill since the printer resolution is finer.

    Steve
    Attached Files Attached Files

Posting Permissions

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