Re: text position on a chart

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



A textbox will not move if its text changes. A chart or axis title will
move. A data label will move, depending on its position.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:340E8178-8C81-4E0E-A385-DEC2A7682BB0@xxxxxxxxxxxxxxxx
Is there a way to set a text's position on a chart so that if the text is
referring to a cell the position of the text will always be aligned? I'm
linking text on a chart to a cell, and if the cell has more or less
characters the position of the text always changes. I would like to left
justify the text or something. Thanks.


.



Relevant Pages

  • Re: Dynamic chart, OFFSET, #N/A Help
    ... Jon Peltier, Microsoft Excel MVP ... all 12 lines will point to one same column, but the values on the chart ... linked cell has a value from 1 to 12. ... Is this the refers-to formula for a named range? ...
    (microsoft.public.excel.charting)
  • Re: Adding to texts togther in a data value in a chart
    ... Jon Peltier, Microsoft Excel MVP ... Tutorials and Custom Solutions ... format the cell in the appropriate currency format. ... Select the chart, ...
    (microsoft.public.excel.programming)
  • Re: XL Charts to Word
    ... server loads in the new platform. ... Jon Peltier, Microsoft Excel MVP ... I can copy a given chart to a single cell (chosen by where the cursor ...
    (microsoft.public.excel.programming)
  • Re: Scatter chart for real-time tracking of a single cell value ?
    ... row from the top every time you add one at the bottom. ... Jon Peltier, Microsoft Excel MVP ... have a cell containing an integer number that updates and changes ... be possible to use a scatter chart to do this but I have not been able ...
    (microsoft.public.excel.charting)
  • Re: Dynamic chart, OFFSET, #N/A Help
    ... Jon Peltier, Microsoft Excel MVP ... all 12 lines will point to one same column, but the values on the chart ... linked cell has a value from 1 to 12. ... Is this the refers-to formula for a named range? ...
    (microsoft.public.excel.charting)