How Do I Modify The Comment Marker/symbol

Nov 15, 2008

I would like to insert images (like a questionmark symbol) into a spreadsheet I'm working on, and then when the user hovers the mouse over the questionmark a "help-text" pops up. I've noticed that it doesn't seem to be that simple making a tooltip, however, is it possible to replace the small red triangle that is inserted into the sheet to indicate a comment with an image?

View 14 Replies


ADVERTISEMENT

Copy Contents Of Multiple Comment Boxes And Paste In Single Comment Box

Mar 13, 2014

how to copy the contents of multiple comment boxes and paste in a single comment box.

The big picture is that I have a number of cells with numerical values in and text in comment boxes. I want to be able to click a button to copy the contents of the comment boxes and paste them, along with the numerical value from the cell, into a single comment box, ordered by highest to lowest value within the comment box, then delete the original cells and comments.

I am quite new to VBA but have been coping quite well so far with information of the web and analysing recorded macros.

View 6 Replies View Related

Bar Chart With Marker

Feb 16, 2007

to create a chart which shows a current value in relation to it's annual high and annual low. I've created a bar chart and added a series with a value of 100. The next series I added is the value of the marker I would like to ride along the bar.

My question is how do I change the marker value series from a bar to just a marker? I would like the chart to look like this (except a bar, not a line):
__________

View 9 Replies View Related

Vary Data Marker Size By Value?

Apr 17, 2014

Is it possible to vary the size of data markers (eg spots) in a chart by their value?

View 2 Replies View Related

Automate Marker Options In Spreadsheet?

Jul 2, 2014

I have a scatter plot in which there are, for example, twenty plotted points representing one of three major categories.

We're using a red square, green triangle and blue circle to represent our categories on the graph. Going in to every plot point and manually changing each point so that it has the proper color and style is very time consuming.

Is there a way to designate in the spreadsheet (in its own column or something) that I always want the plot point to be represented in a certain way (like a red square) when graphed?

View 4 Replies View Related

Image As Custom Xy Chart Marker

Oct 19, 2007

I'm trying to use an image as a custom marker on an XY scatter chart. The jpg image is embedded on a separate worksheet and when I copy and paste it via code it seems to be arbitrarily resized. I've also tried to resize the embedded image and set the marker size but it always appears about 3 times the size of the original image. See CASE -0.5 below.

Set seriespoint = chtBaseArea.SeriesCollection(" Events").Points

For i = 1 To rngCombPointsY.Rows.Count
With seriespoint(i)
.HasDataLabel = True
.ApplyDataLabels Type:=xlDataLabelsShowLabel
.DataLabel.Text = rngCombPoints. Cells(i, 1).Value
.DataLabel.Position = xlLabelPositionAbove
.DataLabel.Font.Bold = True
.DataLabel.Font.Size = 8

Select Case rngVehicleY.Cells(i, 1).Value

Case -0.5
Set shpTemp = wrkshtGraphics.Shapes("Soyuz_Small_Icon")
shpTemp.Copy
.Paste
.MarkerSize = 10

View 3 Replies View Related

Adding A Coloured Marker On Chart Y Axis.

Aug 7, 2009

I have a simple Excel 2007 column chart which has names listed along the y axis for each column. Associated with each name in a small table is a colour reference. Is it possible to add a small marker (say a triangle or something) that aligns with each column?

Or possibly (or in addition) colour each column differently and in accordance with the assigned colours? I'm doing this with some vba code. but if someone can point out the general principle I should be able to work that in.

View 3 Replies View Related

Hiding The Active Cell Marker / Placeholder

May 24, 2006

I feel a bit silly asking this in the presence of so many obvious excel gurus: but here it goes. I've created some user forms, activex controls, etc. that do a series of complex calculations, supported by VBA and it's at the point where I want to roll it out. How do I hide / get rid of the active cell marker on the sheets? I've looked in the "options - view" section and have lucked out.

View 2 Replies View Related

Changing Marker Size In Charts For All Series At The Same Time?

Apr 24, 2014

I have a chart with 5 different series. Instead of editing each one, say the marker size, is there anyway I can change the marker size for all of the different series at the same time?

View 1 Replies View Related

Graphing - Macro Won't Change Marker Fill Colour

Jan 14, 2014

I'm recording a macro, so a line in my graph is a specific green. The marker fill won't retain the green, it always ends up blue. the lines and marker line is green. no matter what color I try the marker fill will always be blue. How to correct this?

View 6 Replies View Related

Setting Chart Marker Based On Cell Format

Apr 12, 2006

I have a dynamic chart which I would like to show markers in a SeriesCollection anywhere the backcolor of any of the corresponding source cells is ColorIndex = 36; otherwise no marker is shown. Something along the lines of:

VB: AutoLinked keywords will cause extra spaces before keywords. Extra spacing is NOT transferred

when copy/pasting, but IS if the keyword uses "quotes".
With Sheets("Chart").ChartObjects(1).Chart.SeriesCollection(1)
For i = 1 To UBound(.Values)
If "something here to check if .Interior.ColorIndex = 36" Then
.Points(i).MarkerStyle = xlMarkerStyleCircle
Else
.Points(i).MarkerStyle = xlMarkerStyleNone
End If
Next i
End With

View 9 Replies View Related

Excel 2010 :: Creating A Simple Line Marker Graph?

Mar 2, 2014

I'd like to create a simple graph exactly like the one on the picture, but for the life of mehow to do this on Excel 2010.This is the data I have:

Seperation First target Second target
0 59.00% 0.00%
2 64.28% 40.62%
4 62.68% 48.99%
6 60.81% 65.83%
8 61.82% 70.21%

View 6 Replies View Related

Excel VBA - Change Marker Styles For All Series Excluding Unmarked Lines

Aug 4, 2014

I have a macro that changes the marker style for all series in a scatter chart, chosen through an input box.

[Code].....

It works nicely, but I want it to exclude any series that do not have markers (i.e. lines used to indicate a reference value). I've tried an if-then statement after the With statement, but it will add markers to any line series:

[Code] ......

Basically, if the series has markers or line+markers, I want it to change the marker style, otherwise do nothing with the series.

View 5 Replies View Related

Excel 2010 :: Add Pie Chart Into Data Point Marker On Line Chart

Nov 27, 2011

I am looking for a creative way to display a pie chart within a data point marker of a line chart.

My database has 3 value columns, Type1, Type2 and the Total (Type1 + Type2)
these are recorded per day (Date, in Column A)

I have a line chart that displays the total by date, but I want to find a way to display the percentage split of a particular day by type.

I was thinking to load the chart image into the Data point marker, but i don't think that is the best way as the data is updated daily and I would have to do it each day for a few line charts.

The other way I was thinking about was to have a generic Pie chat in the Line chart (Maybe in a corner) and the pie would update depending on way date series was selected or Mouseover'd)

the way that I am approaching it at the movement (Not the best way and by far not the coolest way. Is to have a list of all the dates in a column next to the Line chart and using some VBA, what ever date is selected in the column the pie chart displays the corresponding data. But eh challenge is that when there is alot of dates, I am going to be scrolling up and down.

I am using Excel 2010, but I cant not use the slicer's as the other users do not have 2010, they have 2007.

View 1 Replies View Related

Box Symbol

Oct 9, 2009

I have a sheet that when printed out, will have 1 or more check boxes (depending on a formula) beside various items. Basically, if in a datafield it shows that there should be 3 boxes beside a line, it will show similar to this (except the O's are check boxes).

Usable 3 times per day. O O O

In the actual symbols list, there are no such symbols. I think there must be another type of symbol available as I use: ►

I grabbed that symbol from another spreadsheet, and I have no idea where it came from. I have wanted a similar arrow that points to the left or up, but I have no idea where to find them. I only know that the spreadsheet accepts a copy/paste of this symbol, and it does not seem to be related to any particular font set.

where I could find a "empty box" symbol, and also tell me where symbols like ► come from.

View 9 Replies View Related

Use The Following Symbol In VBA? ,, ▬

Aug 19, 2009

I need to use the following symbol (,, ▬ ) to show when my prices went up or down but when I try to use them in the VBA, they are replaced by a ?

I considered using the CHAR function, but its 255 characters do not incorporate the one I need.

View 7 Replies View Related

Delete Everything After A Symbol

May 22, 2008

I have a large list of data.
Approx 10,000 rows.

All I'm looking to do is delete in each row everything after the / symbol.
So everything after a forward slash gets deleted.

All my data is in ColA from A3 downwards.
Ideally would love a macro I can assign a button to.
As an example;

info@123croieres.com/Categories/travel-and-tourism-lodging.htm
So the above after the macro run would look like;

info@123croieres.com

View 9 Replies View Related

Add The Degree Symbol

Feb 16, 2009

I'm logging temperatures and I want to add the degree symbol "" to the end of the numbers, how do I do that? It's easy if I just use one number (#), but how do I do it when adding the lowest and highest in the same cell, e.g. 33-35?

View 9 Replies View Related

Insert Symbol

Feb 20, 2007

i would like to automate the inserting of the symbol ...

i can do in a cell as the first entry, but i can't do at the end of a string's entry in a cell...?

ActiveCell.FormulaR1C1 = ""

or

ActiveCell.FormulaR1C1 = "Schukas"

View 9 Replies View Related

Symbol Appear When I Type A Certain Character

Jul 10, 2008

I am trying to create a document and i'm not sure if this is possible or not, but i'd like to type in a number in column A (1-10) and then in column B have a symbol appear corresponding to the number.

So if i type in 5 in Column A, Column B will have 5 squares pop up (or something along those lines), etc.

View 14 Replies View Related

Counting Symbol Checkmarks

Oct 19, 2008

I would like to count all fields which contain the symbol checkmark.

In another instance I am using the formula
=COUNTIF(B124:B137,"X") to count all fields
which contain an X.

However I don't know the reference for the symbol checkmark.

View 4 Replies View Related

Getting Plus Symbol To Appear In Front Of Appropriate Values

May 23, 2013

I am trying to create a custom number format that will put a plus sign in from of the value in a cell if the value is positive.
Here is what I have been using:

+#,###;-#,###;"On Forecast"

There have been a few problems with this. Firstly, the values are have two decimals, and I have not been able to adjust it accordingly. Secondly, there are some cells that contain only a zero, and the custom format above changes the zeros to 'On Forecast. Other than these two issues, that custom format works.

View 1 Replies View Related

Symbol For Text In A Formula?

Nov 4, 2013

I am wondering if there is a symbol for "text" that I can use in a formula. I.e., =if(C="text", "", INDEX(C:C,MATCH(D16,A18:A23,0)))

View 4 Replies View Related

Macro To Replace Symbol

Jul 9, 2014

I'm using a large database - excel based, with lots of VBA and macros inside - where the default decimal format is “.” (period). When I copy and paste into a normal excel workbook format I want to replace the periods with comas. The paste function I'm using is “Match Destination Formatting (M)”.

I've recorded a macro to replace all of the periods with comas - still some of the values come up as a whole number, the period not being replaced with the coma.

I've tried almost all of the formats - text, general, number .... Still does not work.

View 7 Replies View Related

Show Symbol Dialog

Jul 15, 2008

I want to show the insert symbol dialog through vba code. How?

View 12 Replies View Related

Adding A Value/symbol In Between Words

Jul 27, 2009

is it possible to take a cell, and add a symbol in between every word?

for example:
cell1 = i am having a good day
desired cell1 becomes = i-am-having-a-good-day

cell2 = super awesome
desired cell2 becomes = super-awesome

i have looked into the option of using Data > Text To Columns, then using = CONCATENATE(B54,"-",C54,"-",D54) to form the string

however, since the different cells have different lengths of words, the concatenate(cell,"-",cell...) is not flexible...

View 2 Replies View Related

Copy Format Symbol?

Jan 10, 2010

For copying cell content into an other cell one can use = in the receiving cell.

Is there an equivalent symbol that will only copy the formatting into the receiving cell, without using format painter?

Can complete formatting instructions for each cell be seen somewhere, similar to the data in the formula bar?

View 12 Replies View Related

Currency Symbol Before Numbers?

Sep 3, 2012

how to add Indian currency symbol before all numbers in my excel worksheet?

View 5 Replies View Related

Extract Characters To The Right Of Symbol

Oct 8, 2013

Data in field A1 currently appears as below.

8/10

I want to extract everything to the right of the "/" in a new field.

The formula that I am using is =RIGHT(A1,FIND("/",A1)-1)

For some reason, I am only receiving a 0 in the new field and not the 10 that I expect.

What's odd is that the formula is working as intended on every other field except this one.

View 6 Replies View Related

Delete Degree Symbol Through VBA

May 22, 2014

Have written all the code to remove various words,numbers, etc from cells but this one symbol...I can not figure it out.

It looks like this:

Its the degree symbol, however using that symbol in VBA has proved to fail me. I have a large data set that is created for import but it will continue to fail until I remove this, Find(Replace) should work right? But using a search in VBA it deletes the entire cell.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved