+ Reply to Thread
Results 1 to 3 of 3

Excel plotting data outside of Chart Area [Combo - Bar - Line]

  1. #1
    Registered User
    Join Date
    01-09-2020
    Location
    Bobland
    MS-Off Ver
    2016
    Posts
    3

    Excel plotting data outside of Chart Area [Combo - Bar - Line]

    Hello Everyone,

    I have a somewhat simple graph using a combo Bar + Line chart.

    This is my data, the date column goes back to October 1st.
    data.png

    This is my chart, so for, so good.
    graph.png

    Then, to have my lines to fill the chart I am selecting "On tick marks" for the X axis.
    And then somehow Excel breaks the chart.
    graph_1.png

    To make it even worse, Excel is plotting the data completely outside the chart area
    graph_2.png

    I have never seen something like this before, I have tried recreating this from scratch so many time and the result is always the same, I don't know what could be causing this.

    Thank you very much.

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

    Re: Excel plotting data outside of Chart Area [Combo - Bar - Line]

    You need to move the lines to the secondary axis and then add secondary horizontal axis. Format this axis to be on tick marks.

    The stuff off to the left is the left side of the cluster of columns for the October period.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-09-2020
    Location
    Bobland
    MS-Off Ver
    2016
    Posts
    3

    Re: Excel plotting data outside of Chart Area [Combo - Bar - Line]

    Hello Andy,

    Your suggestion worked perfectly.
    Thank you very Much.

    I would mark as solved but don't know how, sorry.

+ 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: 2
    Last Post: 02-16-2016, 07:11 AM
  2. [SOLVED] Data is not correctly plotting on line chart
    By Sicfreq in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-05-2015, 09:26 PM
  3. [SOLVED] Plotting two sets of data with different dates on same line chart (Excel 2010)
    By archedjumpshot in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-29-2015, 01:05 PM
  4. Plotting data as an area chart with unequally spaced x values
    By Koala8 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-14-2012, 01:56 PM
  5. Area and Line combo chart
    By Jeff Shaffer in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-22-2011, 10:41 AM
  6. Stacked area and area chart combo
    By [email protected] in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-18-2006, 09:35 AM
  7. Applying data as a line over an area chart
    By ahaigh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-23-2006, 07:30 AM

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