+ Reply to Thread
Results 1 to 4 of 4

Marker or vertical line on Specified Month

  1. #1
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    277

    Marker or vertical line on Specified Month

    Hi All,

    I have line chart with x axis of months(Jan 2017 thru Dec 2017), is there a way to add marker only to a specific month(Say Nov 2017) in order to have a better view. A marker or a vertical line would also work.

    I can do that manually but i am looking for a automated solution using a cell reference or any other approach

    Thanks!
    Last edited by Biplab1985; 02-06-2018 at 05:51 AM.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Marker or vertical line on Specified Month

    do you mean smth like that?
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    277

    Re: Marker or vertical line on Specified Month

    Hi, This will definitely work thank you so much. I have a concern though, the data table of the chart which i need to keep also populates which the data value series. Anyway to get rid of this legend and data values

  4. #4
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Marker or vertical line on Specified Month

    Peltier is an excellent source for chart-related hints and tips.
    Here is a link to a relevant page which provides several methods for dealing with your question and explains each one very clearly.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

+ 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: 7
    Last Post: 08-12-2017, 01:49 AM
  2. [SOLVED] Chart Lengend to show marker style on hidden line - Line chart
    By etaf in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-22-2013, 05:19 PM
  3. Replies: 0
    Last Post: 06-10-2013, 05:28 PM
  4. Marker and Line Color Options in Excel Line Graph
    By Slmoore in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-21-2013, 12:55 PM
  5. [SOLVED] How do I move a line marker on a line column combination chart?
    By dknj30 in forum Excel General
    Replies: 7
    Last Post: 05-08-2012, 09:21 AM
  6. Marker on line charts
    By omer123456 in forum Excel General
    Replies: 2
    Last Post: 01-26-2012, 02:30 PM
  7. Anyone know how to do a line marker?
    By JJExcel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-06-2007, 11:48 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