+ Reply to Thread
Results 1 to 3 of 3

Inserting callout markers in Line Chart

  1. #1
    Forum Contributor
    Join Date
    03-08-2011
    Location
    London
    MS-Off Ver
    2010 & 2013
    Posts
    261

    Inserting callout markers in Line Chart

    Hi Folks,

    Is there any way of being able to insert 'callout' markers or flags in a line chart?

    The idea is that I'd like the ends of those callout markers to be dynamically linked to the June 2019 and March 2020 readings. (effectively assigning a marker to a data point) I'd like it so that even if the axis scales change it remains attached as per my mock up below.

    Line chart with callout flag.jpg

    I'd settle for a single marker but, in an ideal scenario, an ability to add additional markers would be a bonus

    Would welcome any ideas

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

    Re: Inserting callout markers in Line Chart

    Use additional series to hold the call outs. Control which data points of that series appear using a formula
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    03-08-2011
    Location
    London
    MS-Off Ver
    2010 & 2013
    Posts
    261

    Re: Inserting callout markers in Line Chart

    Many thanks Andy

    Achieved exactly what I was looking for


+ 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. [SOLVED] Line chart with markers for events
    By vizzkid in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-10-2017, 03:56 AM
  2. Line with markers chart problem?
    By abiyubi in forum Excel General
    Replies: 2
    Last Post: 01-11-2015, 07:02 PM
  3. Line chart with markers question
    By ckosman in forum Excel General
    Replies: 3
    Last Post: 04-25-2013, 03:06 PM
  4. Line chart with markers question
    By ckosman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-25-2013, 03:06 PM
  5. Line chart-how to connect all the markers.
    By S K ROY in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-29-2011, 06:52 PM
  6. Move markers of line chart
    By Abhi719 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-23-2011, 05:03 AM
  7. Replies: 2
    Last Post: 08-02-2006, 11:10 AM

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