dots

  1. M

    Plot dots on a bar

    Hi there! Please help :) I have a graph with salary range and I want to plot my employees as dots on a bar per grades accordingly. I think I did all right, but my dots (employees) appear on a right side of the graph and not on the bars ( salary range). Both Employees and salary range are primary...
  2. M

    Excel splash screen animated dots on loading

    There are a lot of tutorials in the Internet. However I was not able to find anything suitable. Is there any way to make animated dots on loading? The idea is to make a loop of animated dots on userform so they would appear one after another and then would start over after some amount of...
  3. P

    Most characters

    •••W•••••W11111W22222W•••••••W11•1W1••••••••••W••111•11WWW I have this text string in a single cell and need to count the longest occurrence of dots (in this case 10) can anybody help
  4. S

    Extract Filename (including dots) without extension

    Hello, I canot extract the filename without ".xlsm" because of the dots in the name. The filename is: "Test 01.01.2019" Here are my tries: FileName = Left(ThisWorkbook.Name, Len(ThisWorkbook.Name) - 5) FileName= Len(ThisWorkbook.Name, InStrRev(ThisWorkbook.Name, ".") - 1) The...
  5. B

    histogram - bins unclustered to time

    Hi - the graphic visual I wish to display is eluding me... Data cols are clustered time stamps & appropriate frequency count; - I can display as req with unclustered timestamps - but only as event "dots", not as individual vertical bars wrt time... all attempts to draw the bars from the...
  6. M

    Need macro to Count Number of Dots Before the Word Starts

    Hello guys, In I column some of the cells starts with "." It might be start with two to six dots also i.e ".." to "......". After that word will start. Now i want to count number of dots before the word starts and add the count with value 1 the result should be reflect in corresponding cell in...
  7. K

    3 and 4 Dimensional Chart

    Hi, I'm trying to make a X Y Scatter chart a little more useful. Essentially, I've created something like a "Gartner Magic Quadrant" chart. Easy enough to plot the points based on the X and Y axis values. But, I want to vary the diameter of the plotted points (the dots) based on another...
  8. E

    Being able to pull out highest number when divided by dots and using multiple criteria

    Hi everyone, I was wondering if it is possible for excel to pull out the highest number when the digits are divided by dots. Please note the amount of numbers in between the dots are not constant (although they are always between 1-4 numbers). For example I have a table that looks like...
  9. S

    Charts & Macros: how to shift set of data labels & marker dots periodically

    Hello! There is a graph that I need to update on a monthly basis which contains:- bars showing the value (left vertical axis) for each month for last 4 years - line with the percentages (right vertical axis) - months for the last 4 years (horizontal axis) It has data labels on the bars and...
  10. J

    Extract Middle Words from a Text String with Multiple Dots

    Hi there, I've been searching for an optimal excel formula that could help me to solve the following problem, but I've been unable to find a right solution yet; so I hope you guys can help me! The example would be: black.blue.red.yellow.green.white I'd like to extract just...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top