+ Reply to Thread
Results 1 to 5 of 5

Adding a colored line or gridline to first of the month

  1. #1
    Registered User
    Join Date
    05-30-2017
    Location
    Lake Worth, FL
    MS-Off Ver
    excel 2002
    Posts
    44

    Adding a colored line or gridline to first of the month

    I have a line chart with markers displayed at each data value. The X axis are dates. I also have grid lines, major unit is 7 days and minor units are 1 day. I would like to place a colored line or grid line on the chart on the first day of every month. I have been adding a line via auto shape but anytime I change the zoom or add more dates to the X axis the lines have to be placed back in the proper place. I would also like this line or grid line to be behind the plotted values, not over it as is the case when adding a auto shape. Thanks!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,819

    Re: Adding a colored line or gridline to first of the month

    I would use one of the techniques described here: https://peltiertech.com/Excel/Charts/AddLine.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    05-30-2017
    Location
    Lake Worth, FL
    MS-Off Ver
    excel 2002
    Posts
    44

    Re: Adding a colored line or gridline to first of the month

    Thanks for your reply. Didn't really help though. I guess I will have to keep it as is.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,819

    Re: Adding a colored line or gridline to first of the month

    It is up to you. I am surprised that it did not work, though. If you change your mind and want to try again, let us know what you tried to do and what results you got that did and did not meet your expectations.

  5. #5
    Registered User
    Join Date
    05-30-2017
    Location
    Lake Worth, FL
    MS-Off Ver
    excel 2002
    Posts
    44

    Re: Adding a colored line or gridline to first of the month

    Thanks MrShorty. I will go over it again and let you know what problems I encounter.

+ 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. Listview and colored line
    By Maileen in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-09-2021, 09:18 AM
  2. How do you shade below a specific gridline of a line graph?
    By Wizards in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-12-2013, 06:07 AM
  3. [SOLVED] Including a colored line at the end of a column..?
    By Sokol in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-12-2013, 11:30 AM
  4. Adding a colored shape (rectangle) to a footer
    By tommyfernandez in forum Excel General
    Replies: 2
    Last Post: 12-19-2012, 02:34 PM
  5. Add colored line when field values differ
    By Jeff M in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2011, 04:58 PM
  6. Replies: 2
    Last Post: 02-08-2011, 12:48 PM
  7. Colored Line and Column
    By bogdanl in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-09-2007, 05:32 AM
  8. How do you create a colored probability range around a graph line
    By Caerus in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-22-2005, 05:20 PM

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