+ Reply to Thread
Results 1 to 3 of 3

Add line separator between years in chart

  1. #1
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,173

    Add line separator between years in chart

    I don't know if this is even possible but I am trying to come up with a way to add a line separator (or something similar) between years for a chart that is interactive (I have a scroll bar that is linked to the chart and 10 years of monthly data).

    The axis labels are formatted as "mmm" and I don't want to change to format "mmm-yy". I am hoping there is a way to add this separator as it is very hard to identify what year a user is looking at as he/she scrolls through the data.

    I have attached a sample of spreadsheet that better clarifies how it is currently set up and the desired look.

    If this is not possible, any other suggestions are surely welcomed. Thanks
    Attached Files Attached Files
    Last edited by maacmaac; 10-03-2010 at 11:36 AM.

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

    Re: Add line separator between years in chart

    Add another series as xy-scatter on secondary axis.
    Use Y error bar to draw the line.

    I have added code to update the scrollbar and secondary horizontal axis when the number of points changes, via Change event on E4.

    There are also 2 new named ranges.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,173

    Re: Add line separator between years in chart

    That is awesome! Better than what I was looking for. Thanks for the solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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