+ Reply to Thread
Results 1 to 2 of 2

Why does my secondry axis data only plot half the data points

  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Why does my secondry axis data only plot half the data points

    I have two series of data. The y axis for both is a date series (week commencing) there is a primary and a secondary x axis.
    The primary is charted as a bar chart. The secondary is a line chart. The secondary has data from 01/04/2019 to 03/06/2019 but is only plotting a line from 06/05/2019.
    On the data series list to the right of the graph. For MS meters and MS Jobs as well as the description there is a list of values.
    I have two questions:-
    1 Why is the Jobs data not plotting from the start.
    2. Why does the data series list behave differently for BR values than for MS values.
    I hope this will become clearer when you see the work sheet.
    John
    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: Why does my secondry axis data only plot half the data points

    Check your settings for how th line treats gaps, empty and hidden cells. Use Select Data dialog.

    Check the cell ranges being used for series name. BR Meters gets it text from contents of D10:E10. Whilst MS Meters uses D17:AC17
    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. Add data label when hovering mouse over data points on a XY scatter plot.
    By mingxia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2016, 01:53 PM
  2. Secondry Axis
    By bananacitizen in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-31-2015, 04:22 AM
  3. How to plot points on a X-Y axis
    By veritas100 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-21-2015, 06:45 PM
  4. Labeling the x-axis on a scatter plot at specific points
    By CMEjack in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-06-2013, 04:25 PM
  5. How to plot the data if I have more than 32,000 points ?
    By jdbaba in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-17-2010, 06:47 AM
  6. Replies: 2
    Last Post: 06-21-2006, 10:10 AM
  7. [SOLVED] How do you plot data points on a state map?
    By HTucker in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-21-2005, 03:00 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