+ Reply to Thread
Results 1 to 2 of 2

How to make text follow a line chart

  1. #1
    Registered User
    Join Date
    03-20-2013
    Location
    Grantham, UK
    MS-Off Ver
    Excel 2010
    Posts
    1

    How to make text follow a line chart

    Hi all, first post - so forgive me if this should be in the VBA section.

    I'm trying to achieve a couple of text labels to follow a line/area on a chart on a dynamic/automatic basis, where the angles of the lines/areas can change depending on the inputs to the chart. Is this something anyone can help with? Currently I'm doing a manual rotation of text boxes.


    Example one shows what I'm trying to achieve
    example 1.PNG

    Example two illustrates that the charts can change quite a bit.
    example 2.PNG

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: How to make text follow a line chart

    Simplest thing would be to label the end point and avoid rotating the text.

    If you must rotate then VBA will be required.
    The problem is not applying the rotation but working out what the angle should be. Hard to tell from pictures but you would need to determine which 2 datapoints to use in order to calculate the incline angle
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 07-19-2018, 02:23 AM
  2. Line chart too wide (52 weeks) How to make it the line chart automatically?
    By sovietchild in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 06-26-2016, 08:20 PM
  3. Replies: 3
    Last Post: 05-05-2015, 12:43 PM
  4. How can I make a line chart with all the data in column B and D and E?
    By sunheroj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2012, 02:35 PM
  5. Replies: 2
    Last Post: 11-14-2012, 08:59 AM
  6. Replies: 4
    Last Post: 07-05-2006, 11:10 AM
  7. make line in chart start at y axis
    By Tone in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-05-2005, 05:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1