Hi,
I have attached a sample file with my code in it.
What i am trying to do is Superscript the Letters only and not the numbers. Interestingly, the code does superscript each data label correctly, but once it moves to another datalabel in the same series or other series, it seems to...
hi,
i am trying to Superscript the a portion of the text in datalabels in a chart placed on a worksheet.
Set dl=Cht.SeriesCollection(j).DataLabels
dl(i).Characters(Start:=LStart, Length:=1).Font.Superscript =msoTrue
but it seems to Superscript the entire data label text. Also it seems to...
hi,
changed formula this way:
{=IF(ISERROR(INDEX($F$2:$H$6,SMALL(IF($A$2=$E$2:$E$6,ROW($E$2:$E$6)-ROW($E$2)+1),ROW($E$2:$E$6)-ROW($E$2)+1),$B$1)),"",INDEX($F$2:$H$6,SMALL(IF($A$2=$E$2:$E$6,ROW($E$2:$E$6)-ROW($E$2)+1),ROW($E$2:$E$6)-ROW($E$2)+1),$B$1))}
:)
Hi,
I have a table like this:
i want to populate a data validation list using a named range created by filtering values in above table on below 2 criteria:
Services : Service2
Country : Country3
I am trying something like this which is not working properly...
Hi Atul Rajratna,
the formula posted by Luke M is an array formula. as such you need to press F2 and then Ctrl-Shift-Enter for the dates to appear.
Cheers! :)
hi Prasaddn,
to answer your question, the rng1,rng2,rng3 are holiday ranges for every country. as such they are put in different columns so that a combination of country holidays can be feeded to the WORKDAY function.
as for pressing F9 for getting the array values for the dates, i already...
Hi,
I am trying to find out a way to join a number of holiday ranges (defined names Rng1,Rng2,Rng3) lying in different columns into a single range and feed it to the WORKDAY function. however the WORKDAY function does not seem to work. used it as an Array, still not working...
Excellent Luke, this is awesome!
Though a workaround for double-letters considering condition #3 would be better, this definitely does the works for singular letters.
Thanks and best regards. :)
Hi Luke,
Thanks for explaining in a simplistic manner :)
So, what i infer is that these functions won't work for letters like AA, AB, CD, CF etc?
And can i call these in a worksheet_Change event by passing them a cell range, so that user can type in letter/number in either column 1 (or...
Hi Luke,
Could you explain me both these codes as its not commented? for e.g. why are you incrementing i = i + 3 in the Do Loop?
Thanking you in advance :)
Hi Luke,
I have already tried that option, but it does not seem to align the x & y axis to the vertical and horizontal edges of the picture.
If you want, i can post a sample for you to see the code.
Hi,
I am trying to properly align an embedded XY Scatter chart in a sheet, to a background picture, but the chart plotarea does not coincide with the picture. It keeps on shifting. I have tried Dick Kuslieska's example to pin the chart and picture edges to worksheet cells, but it does not seem...
I am still not able to align the chart properly. Not even to cells using Dick's example.
There must be something which is triggering that error for mychtobj.chartArea. Is it something to do with focus of the chart? e.g. Chart send to back or bring to forward?
I have tried your suggestion but found that its happening only with the .ChartArea part starting with viz.
.Top = Top1 - os
...
http://rapidshare.com/files/441958213/TestIt.xls
[see attached]
i used you code...
' align chart plotarea with picture dimensions
Const os = 50
With myChtObj.Chart
With .ChartArea
.Top = Top1 - os
.Left = Left1 - os
.Width = Width1 + (2 * os)
.Height = Height1 + (2 * os)
End With
With .PlotArea
.Top = Top1
.Left = Left1
.Width = Width1...
Hui,
a pot can have multiple pans in it and their number can vary. similarly, the number of pots can vary. i hope you understanding what i am trying to convey.
so i cannot use :
rngChtData.Cells(iRow, 1).Offset(0, 4)
it should be some variable which i would determine at the onset itself...
Hi Hui,
Thanks for the info.
myChtObj.Chart.SeriesCollection(iRow).MarkerForegroundColor = mycolor(rngChtData.Cells(iRow, 1).Offset(0, 4))
My problem is, how do i determine how many offsets to make, as next time, each pot size may change. i need to group & color similar values in the pot...
Hi Hui,
I have achieved 1] & 2] but stuck on the 3rd part.
How do i loop through the series groups and color their datalabels and series-names using a similar color for each group?
Also, i am not able to correctly align the chart plot area with the edges of the picture (excluding the 2...
Hi,
1] I am trying to create an XY Scatter chart and align the 4 corners of its plot area to the 4 corners of a background picture so that the chart axis points meet the background pics corners correctly. The chart X & Y axis should not be visible.
2] I want to delete & create the chart(NOT...
Thanks Hui.
I have used manually created the background as a picture and superimposed the plot area of the chart onto it. aligned the points to the plot area by using dummy points for the 4 corners, like:
0,0
0,100
100,0
100,100
Then used "Bring to front."
Though i still have to...