positioning

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

This Week's Hot Topics

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
Top