Results 1 to 2 of 2

Bubble chart with additional Y axis values

Threaded 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

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