Search:

Type: Posts; User: Rajan_Verma

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    0
    Views
    4,381

    Protected: Link Chart

    Rajan Verma has posted the following on 06-15-2018 03:56 PM:

    There is no excerpt because this is a protected post.

    Protected: Link Chart

    ...
  2. Replies
    0
    Views
    3,656

    Bullseye Chart -3

    Rajan Verma has posted the following on 05-28-2016 02:06 PM:

    Download Chart from here More Charts Bullseye chart
  3. Replies
    0
    Views
    5,045

    Bullseye chart - 2

    Rajan Verma has posted the following on 09-02-2015 12:38 PM:

    Download the chart from hereFiled under: Charts Tagged: bullseye, Bullseye chart, Excel...
  4. Replies
    0
    Views
    5,788

    Link Chart 3

    Rajan Verma has posted the following on 02-28-2015 11:35 AM:

    Download the file from here see Link Chart*2 see Link Chart*1 Thanks RajanFiled under: Chart, Excel Chart Tagged: Excel Chart,...
  5. Replies
    1
    Views
    6,323

    Multi-Axis line graph

    Rajan Verma has posted the following on 02-19-2015 05:27 PM:

    I am playing with XY these days and come up with this Multi – Axis line graph, have a look here. This is how this*chart accept the data...
  6. Replies
    0
    Views
    5,639

    Link Chart 2

    Rajan Verma has posted the following on 02-16-2015 01:25 PM:

    The last chart i posted here was showing item link to a category and vice versa , This one*shows each items links with other items. *...
  7. Thread: Link Chart

    by Rajan_Verma
    Replies
    0
    Views
    5,784

    Link Chart

    Rajan Verma has posted the following on 02-13-2015 12:22 PM:

    here is another graph i have created using XY to show the items under a category or category belongs to multiple items. see the below...
  8. Thread: Tree Chart

    by Rajan_Verma
    Replies
    0
    Views
    6,015

    Tree Chart

    Rajan Verma has posted the following on 02-11-2015 06:28 PM:

    Hi Guys, This chart shows the*hierarchy, anyone can use this to build organization chart, family tree etc. i have tried to make it...
  9. Replies
    1
    Views
    6,118

    Sort Data In Excel Using Formula

    Rajan Verma has posted the following on 06-28-2014 02:31 PM:

    Excel provides SMALL and LARGE formula to get sorted numeric values , but sometime we need our string/text data to be sorted by formula...
  10. Send E-mail using Other account by outlook.

    Rajan Verma has posted the following on 09-29-2013 10:22 AM:

    * Sometime there are more than one account are configured in outlook and when we use VBA to send Emails, it use the default account....
  11. Faster ?

    Faster ?
  12. Replies
    4
    Views
    1,297

    ="Q"&ROUNDUP(RIGHT(A2,2)/3,0)

    ="Q"&ROUNDUP(RIGHT(A2,2)/3,0)
  13. And now i think, you think i dont know right ? ...

    And now i think, you think i dont know right ?

    we are not converting all formulas to values,the header of this post is Convert "Specific" formula to value, which means if you have lots of formulas...
  14. Convert Excel Formulas That Contain Specific Function In To Value

    Rajan Verma has posted the following on 09-27-2013 03:44 PM:

    Many times i have seen this query on Excel discussion groups and forums to convert values for a specific formulas on worksheets. so i...
  15. Manipulate VBA Array Object Using Class Module

    Rajan Verma has posted the following on 12-19-2012 07:02 PM:

    Although VBA is a great language to manipulate office objects accordingly, but when it came to array handling *there are lack of method...
  16. Replies
    0
    Views
    4,789

    Calling UDFs by Hyperlink

    Rajan Verma has posted the following on 06-05-2013 01:34 PM:

    So you are creating a dashboard and you are in a deep thought , thinking what should I add to make it more interactive You have added...
  17. Thread: Indexer

    by Rajan_Verma
    Replies
    0
    Views
    5,689

    Indexer

    Rajan Verma has posted the following on 03-01-2013 11:50 AM:

    hi Guys, it took my lot of time to create home/Index tab to navigate in excel workbook, i always need it in most of dashboards ,dont...
  18. Replies
    0
    Views
    6,141

    Change Hyperlink Screentip

    Rajan Verma has posted the following on 02-27-2013 02:28 PM:

    It may take lot of time to change screen tip of each hyperlink in Excel, here is a code can do in few seconds here you go : Sub...
  19. Replies
    0
    Views
    6,535

    Hierarchy Chart :

    Rajan Verma has posted the following on 11-23-2012 06:49 PM:

    Hi All, I have customize stack bar chart to a hierarchy chart by using some VBA, This chart displays the next level data of a selected...
  20. Replies
    0
    Views
    6,469

    Encrypt and Decrypt Text

    Rajan Verma has posted the following on 11-23-2012 06:31 PM:

    Here is a basic Function to Encrypt and*Decrypt* any text Public Function evtEncrypt_Decrypt(strText As String, strPWD As String) As...
  21. Replies
    0
    Views
    6,416

    Comment Formatting

    Rajan Verma has posted the following on 11-06-2012 07:43 PM:

    This code can be use to Format a Comment , you can make your excel cell comment bit beautiful by using below *code * Sub...
  22. Replies
    0
    Views
    6,576

    Get Random List :

    Rajan Verma has posted the following on 10-15-2012 08:02 PM:

    Here is a code to get random list in array,*you can pass top and bottom value. Function GetRandList(ListCount As Long, Bottom As Long,...
  23. Replies
    0
    Views
    6,866

    Find Mismatch Characters:

    Rajan Verma has posted the following on 10-10-2012 08:55 PM:

    *Here is a code to highlight the misspelled characters in two Text paragraphs suppose you have data like this table, and you want to...
  24. Replies
    16
    Views
    16,122

    Exclude Contents From List :

    Rajan Verma has posted the following on 10-04-2012 10:14 PM:

    Hi, What would be your approach to do this job * Suppose you have 2 List As showing below , and you need to remove List2 contents from...
  25. Automatically Create Multiple Dynamic Named Ranges Using VBA

    Hi

    Most of time we need to create dynamic name ranges to use them in charts n all , i have created an add-ins, that will do this job for you,
    see the attached add ins here
    707

    when you will...
Results 1 to 25 of 81
Page 1 of 4 1 2 3 4