+ Reply to Thread
Results 1 to 3 of 3

Plotting the brand

  1. #1
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Plotting the brand

    Hi All,

    Here I am attaching a excel explanation for plotting the brand from a text string.

    Regards,
    Ankur Shukla
    Attached Files Attached Files
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Plotting the brand

    Although I have 1 remark. Why not make Brand_List a dynamic range instead of a fixed one so you can add or delete brands freely without having to append formula in NameList every time.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Plotting the brand

    Quote Originally Posted by bakerman2 View Post
    Although I have 1 remark. Why not make Brand_List a dynamic range instead of a fixed one so you can add or delete brands freely without having to append formula in NameList every time.
    Yes it is good idea I will add this too in this file.

    Thank you for consideration it

+ 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. Brand new to the forum
    By samsung1234 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 07-04-2017, 02:46 AM
  2. [SOLVED] Sales brand awards
    By makinmomb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-27-2015, 03:44 AM
  3. [SOLVED] Pulling unique brand name
    By makinmomb in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-03-2015, 01:25 PM
  4. Brand new!
    By corrugator in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-30-2014, 10:35 AM
  5. Help plotting filled shapes (currently plotting outlines using scatter)
    By j_man2211 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-23-2012, 10:34 AM
  6. [SOLVED] Rank by Brand by Product
    By som3on3_10 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-01-2012, 04:52 AM
  7. Hi I'm Susan -- Brand New
    By SusanGravino in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 05-24-2012, 02:16 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