1. H

    Add shape to fixed position in a chart

    Hi guys, I've used the information on this board quite often, first time to ask a question myself. I didn't seem to find anything simular on the board and hope I formulate this question clearly and in the correct form... My problemconcerns the positioning of a shape in a chart. The chart itself...
  2. 6

    Excel 2016

    Hi there, I just upgraded from Excel 2010 to Excel 2016 and can’t work out some of the differences. I customize the Home tab by re-positioning “Editing” and “Cells” but when I restart Excel the tab has reverted to the default positioning? When I split the view each workbook has it’s own...
  3. J

    VBA Chart Positioning with a loop

    <body id="************" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody style="margin: 0px; padding: 0px; border: 0px;"> 0down votefavorite I have a loop creating 10 charts using Range Offset to increment 2 columns at a time. The issue i...
  4. L

    Inserting a Shape (diamond) in a cell referenced by a date.

    Hi All, I currently have a spreadsheet that uses rectangle shapes as bar graphs. The graph's sizes are adjustable by a calculation I came up with based on start and end dates. What I would like to do now is place multiple milestones on the graph at a week by week view. There are about 600...
  5. K

    Positioning a Chart

    I cannot get this chart to position on the page where I want it to. It will not move to the left. I want the Chart to go across cells E4:K4 and the height to be from E4:E18. Sub Charts() Worksheets("Reports").Activate ActiveSheet.Range("B6:C31").SpecialCells(xlCellTypeConstants).Select Set...
  6. B

    Automatically changing the height of a row depening on the data in a specific cell

    Hi all, Im looking for a row to be formatted in such a way that the height automatically changes depening how much data is in a cell within that row. The cell in question is wrapped and can either have say from nothing to numerous email addresses present. Almost to have the effect of double...
  7. K

    Macro Rectangle Positioning

    Hi, I am a total VB newbie -with some googling, i have managed to draw 3 rectangles (3 macros) whose dimensions are picked from cells. I want to be able to position them such that the 3 rectangles share the same bottom-left coordinates (0,0). Also, i have written a macro to generate all 3 at...
  8. B

    Replace Words from end to beginning

    Hey MrExcel ! i have a question about replacing over 1700+ rows words.. this is what needs to be done basicly; row1: word1/word2/word3/word4 I want to replace the words in this way, note the numbers; word4/word2/word3 I want to replace word1 with word4, deleting word1 but keeping word4 at...
  9. A

    Graph Positioning

    Hi I would like for a graph to stay stable in its position regardless of if columns are re sized or re positioned, however I would like them to move when ROWS change sizes or are hidden/unhidden I am aware of the format chart area properties object positioning, however because I have multiple...

Some videos you may like

This Week's Hot Topics