+ Reply to Thread
Results 1 to 4 of 4

How do I add line/show 2nd set of data>

  1. 01-19-2021, 06:38 AM #1
    rayted
    rayted is offline
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    How do I add line/show 2nd set of data>

    Hi guy6s

    My chart has a grey line in the legend but this is not showing on my chart//... how do I add this please?

    tahnk you!
    Attached Files Attached Files
    Thanks,

    R.


    Reply With QuoteRegister To Reply
  2. 01-19-2021, 06:43 AM #2
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,024

    Re: How do I add line/show 2nd set of data>

    The Y2 axis only ran to 10%. Your data were both >10. So just adjust the Yaxis range.
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 01-19-2021, 07:04 AM #3
    rayted
    rayted is offline
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: How do I add line/show 2nd set of data>

    thank you so much Glenn!
    Reply With QuoteRegister To Reply
  4. 01-19-2021, 07:05 AM #4
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,024

    Re: How do I add line/show 2nd set of data>

    You're welcome and thanks for the rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Show data in Userform Textbox starting at line 1 instead of line 26
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2018, 01:02 AM
  2. When filtering on Pivotchart to show data for 1 manager (values as %) the line goes flat
    By Lecky in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 01-21-2016, 11:27 PM
  3. When filtering on Pivotchart to show data for 1 manager (values as %) the line goes flat
    By Lecky in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-17-2016, 07:04 PM
  4. I need to create a line chart with a shaded area to show difference between to data ranges
    By smotty in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-15-2012, 03:06 AM
  5. Data line does not show (only sometimes) on macro updated scatter plot
    By JackRose in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-13-2012, 05:51 AM
  6. Data doesn't show on total line
    By dawna in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-11-2009, 05:10 PM
  7. Charts - Line Chart, How to Show data Ranges?
    By chickencoop in forum Excel General
    Replies: 4
    Last Post: 01-06-2009, 08:43 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1