+ Reply to Thread
Results 1 to 7 of 7

Two selections overlapping in a chart.

  1. #1
    Registered User
    Join Date
    04-21-2014
    Location
    Lovington,NM
    MS-Off Ver
    Excel 2010
    Posts
    56

    Two selections overlapping in a chart.

    Hello everyone i am needing some help with a project i have going on. In the attachments i have some data and am using a macro to provide specific actions for this data. When you open the attachment you will see a command box that is labeled "Display Chart" and when selected a userform tab pops up. From this userform tab there are 2 drop down menus. What i am looking for help on is i want to see data from one selection from one box show on a chart and then select another selection from the other drop down box and want this data to overlap each other in the chart so i can see the 2 together. I want this to happen to all the selection no matter which one is selected. I am really needing this to happen and any help would be greatly appreciated. Thank you all in advance.
    Attached Files Attached Files
    Last edited by jleal; 08-10-2015 at 07:49 PM.

  2. #2
    Registered User
    Join Date
    04-21-2014
    Location
    Lovington,NM
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: Two selections overlapping in a chart.

    Guys some help with this please!!!

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

    Re: Two selections overlapping in a chart.

    Your code is not handling the values correctly because you are adding numeric values together by using concatenate

    Please Login or Register  to view this content.
    If you select first item in combobox2 then the listindex of zero has no affect, so you code appears to work. Select anything in combobox1, except first item, and any item except first from combobox1 and then the chartIndex value will be missed by select case.

    When combining the plot should the 2 series be put on separate axes? If so is it combobox1 on left and combobox2 on right?
    Do you always want 2 lines plotted or should it be possible to select nothing to plot?
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    04-21-2014
    Location
    Lovington,NM
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: Two selections overlapping in a chart.

    Yes i am trying to see both options plotted at the same time just overlapping each other the left will be first and the right would be second. Yes when the top selections are selected and load charts is clicked even if the selections are the same i want to see them both plotted. I think im having trouble coding the image to do this overlapping motion or i could just be coding it the wrong way in general.

  5. #5
    Registered User
    Join Date
    04-21-2014
    Location
    Lovington,NM
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: Two selections overlapping in a chart.

    Im sorry i forgot to add that the combobox2 is on the left and the combobox1 is on the right. Does this matter? If so i can swap them as which side they are on is irrelevant to what i need. Also even though the y axis or x axis of the chart selections from the drop down menu have less or more range than each other is this even able to be plotted and see both values appear in conjuction with each other?

    Example: Inclination ranges from 0-5 but the RPM ranges from 0-80...is this plot even possible?

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

    Re: Two selections overlapping in a chart.

    This revision loops through your code twice, once for each combobox.
    If the chart exists on the worksheet the data is placed on the secondary axis.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    04-21-2014
    Location
    Lovington,NM
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: Two selections overlapping in a chart.

    Perfect that is exactly what i needed. Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to create (what I assume is) an overlapping chart?
    By The_Snook in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-06-2015, 01:58 PM
  2. Column overlapping in chart
    By nooredein in forum Excel General
    Replies: 1
    Last Post: 04-23-2014, 02:05 PM
  3. Creating an overlapping chart
    By jaywizz in forum Excel General
    Replies: 0
    Last Post: 06-10-2011, 10:13 AM
  4. Overlapping Bars in Chart
    By Jonathan78 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 10-03-2010, 05:09 AM
  5. Overlapping lines in a chart
    By Sabina in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-15-2010, 07:18 AM
  6. [SOLVED] How to plot an overlapping Tubes chart?
    By Overlapping Tubes Chart in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-24-2005, 07:45 AM
  7. [SOLVED] Can I keep the bubbles in my bubble chart from overlapping?
    By B_Gr in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-21-2005, 01:06 PM

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