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
...
Type: Posts; User: Rajan_Verma
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
...
Rajan Verma has posted the following on 05-28-2016 02:06 PM:
Download Chart from here More Charts Bullseye chart
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...
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,...
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...
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. *...
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...
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...
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...
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....
Faster ?
="Q"&ROUNDUP(RIGHT(A2,2)/3,0)
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...
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...
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...
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...
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...
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...
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...
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...
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...
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,...
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...
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...
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...