+ Reply to Thread
Results 1 to 2 of 2

excel repeating the first year in a line chart

  1. #1
    Registered User
    Join Date
    01-23-2018
    Location
    Nevada
    MS-Off Ver
    2016
    Posts
    10

    excel repeating the first year in a line chart

    I have done this chart hundreds of times and never had this issue. Must be something that I am missing. I designate cells a2:a361 as my horizontal axis values and then b2:b361 for my series values. It repeats 1990 in the beginning even though 1990 appears 12 times in exactly the same fashion as the other years 1991 to 2019. the data set is attached. Is this something related to chart design (select data) or formatting the axis?
    Attached Files Attached Files

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

    Re: excel repeating the first year in a line chart

    If the axis is text all values are repeated. The amount of labels actually displayed is due to the huge quantity. If you stretch the width of the chart more repeated periods will appear.

    If you want single year as a date point with the values accumulated you should create a pivot table
    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. [SOLVED] Excel Line chart pulling in deleted dates from prior year
    By Milerac in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-07-2020, 10:49 AM
  2. Year on Year Line Chart
    By WorkWear in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 04-26-2018, 03:43 PM
  3. Replies: 2
    Last Post: 02-10-2018, 12:02 AM
  4. [SOLVED] Add Year Values to X Axis in Scatter or Line Chart
    By sherylt13 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-08-2015, 05:21 AM
  5. Replies: 3
    Last Post: 11-15-2013, 06:28 PM
  6. Replies: 6
    Last Post: 11-26-2012, 05:17 AM
  7. How do I remove repeating line in Excell - Top line on each page..
    By keepon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-23-2005, 08:06 PM

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