• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    superscript/subscript a portion of data label

    It seems nobody seems to know of this issue, on this forum. :rolleyes:
  2. S

    superscript/subscript a portion of data label

    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...
  3. S

    superscript/subscript a portion of data label

    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...
  4. S

    INDEX array formula to return multiple values using multiple criteria

    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))} :)
  5. S

    INDEX array formula to return multiple values using multiple criteria

    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...
  6. S

    Workday with non-adjacent multi Holiday ranges

    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! :)
  7. S

    Workday with non-adjacent multi Holiday ranges

    Thanks Luke, finally someone was able to find a cure. :) Cheers Luke! You are a true Ninja!! :)
  8. S

    Workday with non-adjacent multi Holiday ranges

    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...
  9. S

    Workday with non-adjacent multi Holiday ranges

    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...
  10. S

    number to character and vice-versa

    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. :)
  11. S

    number to character and vice-versa

    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...
  12. S

    number to character and vice-versa

    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 :)
  13. S

    number to character and vice-versa

    Hi, I have a table consisting of 2 columns: blockquote Cell Letter Cell # A 1 B 2 C, D 3, 4 E, F, G 5, 6, 7 H 8 I 9 J...
  14. S

    Properly align chart to background picture

    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.
  15. S

    Properly align chart to background picture

    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...
  16. S

    Create XY Scatter chart with VBA, align plotarea to 4 corners of Background pic

    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?
  17. S

    Create XY Scatter chart with VBA, align plotarea to 4 corners of Background pic

    i am using excel 2003. how would i implement a cell based approach into my file?
  18. S

    Create XY Scatter chart with VBA, align plotarea to 4 corners of Background pic

    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]
  19. S

    Create XY Scatter chart with VBA, align plotarea to 4 corners of Background pic

    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...
  20. S

    Create XY Scatter chart with VBA, align plotarea to 4 corners of Background pic

    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...
  21. S

    Create XY Scatter chart with VBA, align plotarea to 4 corners of Background pic

    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...
  22. S

    Create XY Scatter chart with VBA, align plotarea to 4 corners of Background pic

    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...
  23. S

    Create XY Scatter chart with VBA, align plotarea to 4 corners of Background pic

    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...
  24. S

    Find Legend Key position

    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...
Back
Top