Search:

Type: Posts; User: pbornemeier; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.18 seconds.

  1. Replies
    3
    Views
    158

    Re: 32 to 64 bit

    I googled "64 bit MSCOMCTL.OCX" and found a collection of options to correct similar problems. I am not sure which would be applicable for your situation.
    I am running Excel 2010 on Win7. The...
  2. Re: VBA Compare 2 lists and isolate 2 types of differences

    Glad to help - thanks for the feedback.
  3. Re: Data labels on the outside end of error bars without overlapping?

    Glad to help - thanks for the feedback.
  4. Re: Data labels on the outside end of error bars without overlapping?

    Will the 3 tables you want to plot all be on the same worksheet?
    Will only those tables be on that worksheet?
    Will the chart also be on that worksheet?
    Does the order matter?

    If the answers...
  5. Re: Data labels on the outside end of error bars without overlapping?

    Modified for use with Table References



    Option Explicit

    Sub EditAndMoveDataLabelOnGraphWithTableRefs()

    Dim cht As Chart
    Dim ser As Series
  6. Re: Data labels on the outside end of error bars without overlapping?

    I modified the code to work with the series definitions in the first part of your last post.
    You have to edit these lines to reflect the layout of you data

    lDLOffset = 5 'Column...
  7. Re: Data labels on the outside end of error bars without overlapping?

    To post an image, upload it to an image sharing site then use IMG tags around the link to include it in your post:
    https://cdn3.iconfinder.com/data/icons/developerkit/png/Ball%20Red.png
    I used...
  8. Re: Data labels on the outside end of error bars without overlapping?

    I would guess that the desired graph is a column chart (similar to first chart in this thread) with the organization labels on the horizontal axis, plot values as vertical columns, low/high error...
  9. Re: Data labels on the outside end of error bars without overlapping?

    Post a few rows of your data here and explain how it is incorporated into your graph and I will see if I can figure it out.
  10. Re: Find related items based on multiple criteria > index+match multiple criteria or somthing else?

    You could ensure your specifications in a given column had the same character length then concatenate all columns with dashes into a single column. Index match with the combined column would show...
  11. Re: Remove legend where no data in the chart

    This code with the chart selected
    ActiveChart.Legend.Delete
    or this code with the appropriate chart name substituted for 'Chart 3' and with the sheet holding the chart properly referenced...
  12. Re: How to get two Trendlines to start and stop at two different intervals on a chart

    Option 1
    Put =NA() formula in the 2013-Q1 through 2016-Q4 cells for Model B (D2:D17)

    Option 2
    Perhaps the second trendline could be simulated by calculating its origin and slope then plotting...
  13. Replies
    5
    Views
    171

    Re: Auto Sort from multiple list by Name

    Thanks for pointing that out...I am not being very observant with this one.
  14. Re: VBA Compare 2 lists and isolate 2 types of differences

    This is a simpler version.

    The output is combined to display only rows where the is not one of each Unique Identifier in each list and/or the amounts are different. In addition it also displays...
  15. Replies
    5
    Views
    171

    Re: Auto Sort from multiple list by Name

    It is indeed shorter, but be sure to clear the sorted worksheet before copying rows from names in case some rows were removed from the original list.
  16. Replies
    5
    Views
    171

    Re: Auto Sort from multiple list by Name

    The worksheet holding the names should be named 'Names'
    The worksheet holding the sorted list should be named 'Sorted'
    I am assuming your names list has a header row, sot it is not included in the...
  17. Replies
    3
    Views
    156

    Re: Excel Pivot Table "Insert Column"

    The grade column header did not appear in your desired output, but the values did so I included them. If you only want to extract the questions and comments replace the lines in post #3 with:


    ...
  18. Thread: Sum

    by pbornemeier
    Replies
    3
    Views
    208

    Re: Sum

    Is there any chance of getting something like:

    10/10/2019 17:06:57 1570745217 NONE eagle-inet Tyreek Hill(W) UNPAUSE
    10/10/2019 18:02:55 1570748575 NONE inet-comm Tyreek Hill(W)...
  19. Re: VBA Compare 2 lists and isolate 2 types of differences

    This is a start to what you asked for.
    Some questions have to be resolved before it is complete.
    Note that there was some inconsistencies in the sample data and the sample desired results
    -- ABC...
  20. Re: Shrinking Data Validation Drop List with a column in between

    Will this work for you?

    =IF(COUNTIF($A$1:$A$6,Q1)+COUNTIF($C$6:$C11,Q1)>=1,"",ROW())
  21. Thread: Sum

    by pbornemeier
    Replies
    3
    Views
    208

    Re: Sum help

    Please provide an example of each type of overlapping times.
  22. Re: code compare values of columns into two sheets and result in another sheet

    Can the BRAND column name be used to match the rows between sheets?
    Or can there be the same brand with different TYPE and/or ORIGIN?

    Can there be multiple instances of the same item in each...
  23. Replies
    3
    Views
    156

    Re: Excel Pivot Table "Insert Column"

    Start this code on the (one) sheet containing data.
    The code will have to be tweaked if you have multiple sheets to process.
    If this is the case, please provide information about those sheets.

    ...
  24. Replies
    12
    Views
    671

    Re: Userform Overdue Calculation

    Is the code in post 8 on the userform?
    Is cboStart on the userform?

    If both are true then the error you mentioned in post 8 should not happen because Me.cboStart would be OK

    I thought the...
  25. Re: Can't copy and paste after using VBA code. Any help please

    If you use the 2 buttons then you can remove the Worksheet_SelectionChange code and the copy/paste problem should go away.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4