+ Reply to Thread
Results 1 to 2 of 2

Bubble chart with additional Y axis values

Hybrid View

  1. #1
    Registered User
    Join Date
    12-02-2011
    Location
    Athens, GA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Bubble chart with additional Y axis values

    Hi, I'm new to this forum, and I'm trying to figure Excel out for myself, but it's been very frustrating. I'm trying to create a chart to show horizontal lines for the Y value (or series in a stacked column chart) to refer to the piece heights on a concrete manhole, but I also want to show bubbles to identify the holes at the proper size and height. I've attached a little sketch I made of the chart I want (or something similar) that might help to explain what I'm aiming for. I want to be able to show all three values on the same chart (piece height as lines on Y axis, hole height and hole size). Is there any way that this can be done. I don't know anything about VBA, so this is not an option for me. I've figured out how to make separate stacked column chart (to show piece heights) and bubble chart (to show holes), but there is apparently no way to combine them. Please let me know if you can help.
    Attached Images Attached Images

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: Bubble chart with additional Y axis values

    You can add additional series and use the X error bars to draw horizontal or vertical lines.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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